I would like to have an invoice number created by adding a number in the previous sheet. Each year I create a spreadsheet that holds my time worked for a...

Is there an "official" name for the box in the corner that selects the entire sheet? I'm writing some documentation and I want to call it something besides...

Hello all, and thank you in advance for your help with this odd question: I have a worksheet that started out using all Form Control ComboBoxes. I started...

I can't find the certificate of trust. Can you help?

Hi there, Does anybody know a good way to use Excel to create weekly music charts for my 10 year old son to use? He is currntly writing them out longhand -...

I have a spreadsheet which has one row with data and one row blank, it's about 1000 rows down, is there any way I can delete the blank rows. If I apply...

Hello, I have a user in my group with an XY Scatter chart created in Excel 2007. When selecting the Category Axis and applying the "Values in Reverse Order"...

I note from a previous post that an active cell's reference can be displayed by inserting some code, as follows: Private Sub Worksheet_SelectionChange(ByVal...

I used the following two methods to determine the existence of a spreadsheet on one system, but using the same statements on another system I get Error 9,...

a data extraction from a web site produces this: 849,2300,365086280 6098,99,22710853 3461,99,22711036 128,99,61228398 1161,99,39212169 7590,99,16618984...

I have a file that certain users will open, rename, and use for testing purposes. It contains a macro that I only want to run if the file is the original...

My spread sheet has 5 tabs with different data, when I insert rows or highlight the rows to change the color than the below message pop up. Too many...

I am trying to boldface specific cells within a data table that I display along with bar graphs. I need to differentiate between cells to identify...

I have extended out the margins, set the print area but still cut off the last part of the worksheet. Where do I go from here?

My formulas in excel 2007 stopped working. I use this sheet everday at work and need it fixed asap. Anybody have a solution? I checked excel options to make...

I have the following formula: =VLOOKUP(B27,BOM!$A$10:$M$99,13,FALSE) which is returning an error #N/A. I know the information is there because I can see...

I want to get XL to give me the result of the following type of calculations: 41hr 55mins (entered into a cell as 41:55:00 ?) multiplied by the rate per hr...

I am having a worksheet with a range of data sorted in i.e. 6 columns. The first column is populated with entries consisted of 10 different person names (i.e....

Is it possible to to change the default in excel so 0 values do not display unless desired. As it is now EVERYZTIME I have to go into Windows/excel options...