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
Resize columns wider for pick list by Joe M.
I have some code that widens certain colums when clicked upon so I can see the pick list entire width but don't need the column to stay that width after...
May 11th, 2010 03:13 PM
by Gord Dibben Go to last post
5 270
Conditional Format by Pass-the-Reality
I need a conditional format formula that says if D1 = "N" than cells B1&C1 should be gray. What should I type in the conditional format statement?
May 11th, 2010 02:47 PM
by Max Go to last post
1 231
Locking a file by MD
Is there a way to lock a file so that it can not be copied?
May 11th, 2010 02:40 PM
by MD Go to last post
4 195
Excel 2003 VBA problem by BJ&theBear
Never used R1C1 notation before and I;m not certain that I understand it. The routine below posts a copy of "ProjectID" to the next available line but am...
May 11th, 2010 01:09 PM
by Dana DeLouis[_3_] Go to last post
4 270
unable to open .xlsx file in 2003 version by .xlsx file
unable to open .xlsx file in 2003 version
May 11th, 2010 12:13 PM
by Mike H Go to last post
1 296
adding to lines by balurrpr
Hi, i am getting an output with two rows like - Item Description Category 2300798-2 1.5T HEAD/BODY Receipt Receipt Date Number
May 11th, 2010 11:26 AM
by balurrpr Go to last post
0 201
Can I insert a picture depending on the contents of another cell? by JP
I have a list of data and each individual piece of data has a small logo in the adjacent cell. Can I make Excel insert the picture in various places in the...
May 11th, 2010 11:06 AM
by Jacob Skaria Go to last post
1 268
How do I stop the automatic opening of Template Help in Excel? by TMC
Each time I open an Excel workbook (.xls) that has been built from a template downloaded from sources such as Microsoft Downloads, the Template Help pane in...
May 11th, 2010 08:34 AM
by Collaborative Enterprises Go to last post
6 321
How to change data from two rows into 2 columns by Katherine
Hi I have the following Data Staff A Cellular Phone xxxx Staff A Residential Phone xxxx Staff B Cellular Phone xxxx Staff B Residential Phone xxxx How...
May 11th, 2010 07:03 AM
by BSc Chem Eng Rick Go to last post
1 213
Eureka!! by berticus
Works very well, works on Excel 2007 (XLSX) spreadsheets as well!
May 11th, 2010 06:16 AM
by berticus Go to last post
0 144
Need to populate data from different sheet. by Joe Spindola
I have a drop down list of branch names in one sheet. The source sheet (separate one) contains the values of this list and addresses and contact information,...
May 11th, 2010 04:04 AM
by trip_to_tokyo[_3_] Go to last post
1 183
Conditonal formatting problem! by chrissy2391
Here is what I have: Ideal Variance Minimum Maximum Actual 5 2 3 7 8 0.00375 0.0025 0.00125 0.00625 0.00725 6 2 4 8 3 The numbers in the Ideal, Variance &...
May 11th, 2010 03:16 AM
by chrissy2391 Go to last post
1 158
How do I set up a weighted formula in Excel? by ib1qb
Can someone help me please? I need to do a weighted formula in Excel 2007, where the total of the numbers equals 90% of one number and 10% of another...
May 11th, 2010 01:27 AM
by Billy Liddel Go to last post
2 229
small type when printed by kmonhoff
My worksheet is compressed to really tiny print when I print it to a printer or pdf Create. Only one tab is small print. I can not see anything in page...
May 11th, 2010 01:01 AM
by Bruce Sinclair Go to last post
2 186
Industrial Time look up sheet by Pepino
Hello, I am trying to create a time lookup sheet where at the cross point of Start and End time the result is shown in 100 of an hour. So Row 1 has the start...
May 10th, 2010 11:49 PM
by Fred Smith[_4_] Go to last post
1 193
Need to open eer file without converting 8-7440 to a date? by pnkflydthewall
Trying to pull a report from one program that has file in eer format. Need to open in excel but Excel auto converts a number (8-7440) into a date in August....
May 10th, 2010 11:42 PM
by Gord Dibben Go to last post
1 258
date sorting by rcc
When I try sorting a column of dates, excel puts (for example) 06/2000 first and then 01/2001 next. It obviously makes sense that it would do that, but what...
May 10th, 2010 10:47 PM
by Gord Dibben Go to last post
4 185
Formula Help by Peter
I need to have a cell reference another cell if it meets within a certain time period, So in this case I will use 18:05 as the time. =if(M5=U2,R5,...
May 10th, 2010 10:45 PM
by Peter Go to last post
4 174
importing contacts from excel to Outlook error by geno
I have an Excel spreadsheet of my contacts, and when in Outlook, I am trying to import them into contacts there. I get the following: file has no named...
May 10th, 2010 10:34 PM
by Gord Dibben Go to last post
2 254
Sum Vlookup where there are blanks by KneeDown2Up
Hi Excel 2002 sp3. I have a sheet which has 7 tables (one per day of the week) in which a number of members of staff are listed. Not all the staff are in...
May 10th, 2010 10:30 PM
by T. Valko Go to last post
2 230
Post New Thread


Display Options
Showing threads 1101 to 1120 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 12:06 AM.


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