General

How do I enter rows to repeat on sheet tab?
Thanks! just what I needed "Dave O" wrote: Enter it like this: $1:$6 .... to indicate rows 1 thru 6. ... 1 Mar 2010 02:37

Help!! To modify existing formula
Hi A cell (H6) in my spreadhseet currently contains the following formula: =IF(ISBLANK(G6),"",NETWORKDAYS(E6,G6)) If the value returned is >1 then i want the font in the cell to turn red. Please help. Thanks Dan ... 11 Feb 2010 17:22

Printing dynamic labels
Hi, I don't know if this is possible but here goes. I have designed a 4x6 label. I enter values in two cells. The first cell indicates the beginning of the sequence and the second cell indicates how may labels I want printed. Example ------------ Cell 1: 10 Cell 2: 8 So, I want it to print 8 labels (no... 11 Feb 2010 16:14

sorting help?
Hi- I have a single workbook with multiple worksheets. All link to eachother. I would like to sort ALL the information at once. Can I do this? example of gradebook: I would like to put names in alphabetical order if I add a new student. I have a sheet that is for Daily Participation, Attendance and Testing... 11 Feb 2010 15:05

Error MOVING data: Cannot empty the clipboard
I started receiving this message "Cannot Empty The Clipboard" a couple of days ago. Only when I MOVE data; does not appear when COPYing data. Do not recall changing any settings. Particulars: Office 2007, VISTA Premium, Core 2 Duo, plenty of memory avail ... 12 Feb 2010 03:19

Dynamic Named Range for a Chart
I have a dynamic named range for a data set that I want liked to a chart. When I enter the range "Data" in the data range for the chart it accepts it but when I click back in the data range, the named range is gone. How can I retain the named range so the chart will update if my data set expands? ... 11 Feb 2010 15:05

Word Art won't show up in Print Preview
When using the Print Preview option, neither Word Art or clip art will show up. ... 11 Feb 2010 15:05

Macro to hide rows with zero values in columns
Hi, I've got a large workbook with a minimum of 75 sheets of data. Each sheet contains 8 columns and 237 rows. Many of the rows in the report have zero values in the columns. I'd like to create a macro that will hide all rows with zero values in all sheets. Any suggestions? ... 11 Feb 2010 13:57

Error msg on opening excel workbook
I receive the following error msg when opening an excel workbook: "Cannot find #REF!$B$1, which has been assigned to run each time [WorkbookName]TabName is opened. Continuing could cause errors. Cancel opening [WorkbookName]TabName?" There is no macro associated with this workbook. I have right-clicked on the... 11 Feb 2010 15:05

How do I change the font in the formular bar in EXCEL 2007?
How do I change the font and font size in the formula bar in EXCEL 2007? Mine is barely viewable. ... 11 Feb 2010 15:05