General

An odd question about formatting
Ok, here's a toughie. I have a list of numbers in column A and I would like in column B a smiliar number of asterisks like this: 4 **** 1 * 9 ********* Any ideas? Amy ... 18 Jan 2010 13:11

ordeing columns
Hi, how do I put one column in alphabetical o numerical orer without all the rows going out of sequence - I.e if i want to pyt column D in alpabetical oder I want row 1 to reainm as a whole row despite the facty it has been put in order alphabetcially at column D - sorry if I have not explained myslef properly... 18 Jan 2010 12:02

Sequencial FIXED Numbering
I would like to have sequencial numbering appear in my worksheet without it getting mixed when I filter other columns. Is this possible? ... 18 Jan 2010 12:02

Excel File Overwrite
How can I restore an overwritten file? I was backing up my files and I accidentally saved an old version instead of the new one. This sets me back to May 2009...I cannot find the file I used on Friday Jan 16, 2010. Help please!! ... 18 Jan 2010 12:02

Footer printing in wrong colour
The footer in some of my Excel spredsheets prints the first page's footer in a different colour to the rest of the document. In this case i set all footers to be Dark Blue, Text 2. When I come to print preview it shows the first footer as being in Black and the rest in the Dark Blue, Text 2. This is until I zoo... 18 Jan 2010 10:53

Is there a way to automatically put the $ sign into the formula?
I want to turn this =A1 into =$A$1. How is the best way of doing this. Is there a shortcut....keyboard stroke to do this?? ... 18 Jan 2010 12:02

disable sounds when saving
Every time I save an Excel folder I get an obnoxious sound. This began when I got a new computer with Windows 7. How do I turn off the sound? Please use leeallaben(a)comcast.net for my email. The email here is no longer valid and I don't see a way to update it. Thank you. ... 18 Jan 2010 10:53

2nd to last value in column
Hi everyone. My question has to do with the 2nd to last cell with data in a column. To get the last data, I am using "=LOOKUP(10^100,A2:D2)" but how can I get the data from the cell right above that? For instance, my data looks like this (multiple tabs for different entities): # of Accounts 1/1/10 45 $... 18 Jan 2010 15:25

Background or Header picture should cover entire A4 sheet when pri
Hi, I don't even know if what I need help with can be done, but here goes: I have a picture, .bmp, that I would like to appear at the top of my printed Excelsheet. The challenge is to get the picture to cover the entire sheet with NO margins. The top of the printed paper should not show any white margins at... 18 Jan 2010 06:26

manually selected Excel cell formatting
I've installed Excel 2007 recently. I notice when I manually select non-contiguous cells using the ctrl key that the selected cells are not highlighted like they were in Excel 97. At first I thought I was losing the selection altogether but I noticed that the current cell had a thin outline instead of the heavi... 18 Jan 2010 08:38