A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Change scroll rows from 1 to 3 with mouse wheel by needhelp
Does anyone know how to set the mouse scroll amount from 3 rows to 1 row in Excel 2007? There used to be an option in 2003, but I can't find one in 2007.
May 5th, 2010 04:35 PM
by Bob I Go to last post
1 251
Two different totals in one cell by something68
C D L O P Q R H, AL A, AL A A P SF H, AL 1.0, 1.0 1.0, 1.0 7.50 8.5 0.00 0.00 1.0, 2.0 As you can see, “A” (shown in columns D and L) and “AL” (shown...
May 5th, 2010 03:57 PM
by something68 Go to last post
2 321
How do I create a formula to remove dashes? by jackierae17
I'm new to Excel. I have a huge inventory spreadsheet where I need to change a column to reflect the following. "P01-02-C-1" should become "P102C1" (remove...
May 5th, 2010 03:04 PM
by Pete_UK Go to last post
5 200
clip art in list box by mrmatt67
i want to insert clip art into a drop list instead of text
May 5th, 2010 03:02 PM
by Jim Thomlinson Go to last post
1 186
Count number times text appears in string by nc
A 1 Module: C126, Module: C130, Module: C138, Module: C105 Can any help me write a function that would return the count of a specified text in a...
May 5th, 2010 02:41 PM
by nc Go to last post
0 183
how do I convert pace per mile to total time in minutes in excel? by sisteragent
i have pace per mile in minutes and total distance. I want to calculate total minutes. What are the formulas I use? I'm currently showing pace per mile as...
May 5th, 2010 02:37 PM
by Fred Smith[_4_] Go to last post
2 194
Highlight on Date Problem by Lise
Hi everyone I have the following in conditional format in column A =I54-TODAY()=60 if true highlight Red This is working in most cases but for some reason...
May 5th, 2010 02:25 PM
by Fred Smith[_4_] Go to last post
3 208
Opening a sheet by Eric
When I open up a named sheet sometimes it opens and then closes imediately shutting down excel all together and then restarting. What is the problem? It...
May 5th, 2010 02:24 PM
by Eric Go to last post
0 157
Macro to copy & paste-special-values data to selected worksheets by tomhelle
I have a workbook containing worksheets called “List-1”, “List-2”, “List-3”, “List-4” and many other worksheet “templates”. I need a macro...
May 5th, 2010 02:00 PM
by PY & Associates[_2_] Go to last post
1 190
Formating cells by Shazza
Hi Sharon, Tricky formula situation here.... I wanted to change cell colour when certain cells of the workbook are filled in...I have formatted cells to...
May 5th, 2010 01:56 PM
by Shazza Go to last post
0 173
sort 2 columns alphbetic and make dictionary by Mahmoud Mustafa[_2_]
I'm Mahmoud from Egypt and recently joined to ur group I have a problem with excel file , and need help from u or anyone can help to solve the problem I...
May 5th, 2010 01:24 PM
by Dave Peterson Go to last post
2 252
Splitting cells by fazz
in cell A1 i have the numbers 123456789. i want cell B1 to have numbers 1234567 and cell C1 to have just 89. what is the formula? i have tried text to columns
May 5th, 2010 01:24 PM
by fazz Go to last post
5 179
Time Stamp by Ken
I have a dynamic stock quote in cell "B2" ... in cell "C2" I want to record the exact time that the stock price FIRST reachs a certain price. How do I have...
May 5th, 2010 01:15 PM
by Dave Peterson Go to last post
2 183
Autofill by dewheatley
I'm having a problem with autofill. I can drag and drop but when I want to see the options, before I can mouse over to the options box, the box vanishes as...
May 5th, 2010 12:34 PM
by Malin D Go to last post
2 164
worksheet sliding when cell is tabbed by whatzzup
Good morning, i have a problem where i select a cell and by using right or left arrow the work sheet move rather than the cell, normally when you tab a cell...
May 5th, 2010 12:33 PM
by whatzzup Go to last post
2 166
calulate the number of leapdays between two dates? by leapterry
can this be do this easily
May 5th, 2010 12:07 PM
by Gary''s Student Go to last post
3 201
2007 Pivot Tbl to Access Conversion Issues by LindaSD
I have a large number of 2003 Excel Pivot Tables that connect via odbc to 2003 Access queries. I recently converted one database to 2007. I then converted...
May 5th, 2010 10:56 AM
by Geeta Sonawane Go to last post
1 269
AVERAGEIF by Sasikiran
Dear, I am struggling with AVERAGEIF formula which calculates the average of data of one location without including 0 values. In the below example, would...
May 5th, 2010 10:56 AM
by Jacob Skaria Go to last post
4 146
Recognizing an Unstable Result by Ken
In Column "B" I have a list of results. Some of them have the result of "#VALUE!". I would like these cells to be represented in Column "C" with the result...
May 5th, 2010 10:53 AM
by bala_vb[_6_] Go to last post
2 152
Wingdings 2. Check Mark (P). by Khalid A. Al-Otaibi
Hello; I set the Font into Wingdings 2, and put a formula =IF(G8="",,"P") This to put a check mark if Cell G8 is filled with any data, Now if there is any...
May 5th, 2010 09:11 AM
by ozgrid.com Go to last post
1 327
Post New Thread


Display Options
Showing threads 1321 to 1340 of 139764
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:11 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.