Good afternoon. I have a user who uses excel quite a bit for their job. This has been going on for a while, and has just been brought to my attention. ...

After I have traced a formula using Ctrl+[, what is the keyboard shortcut to return to the same cell where I traced the formula? Thank you!

I have a spreadsheet that looks like the following. Tab 1. Col A=Name. Col B = Task. A B Bob Reconcile Cash Tim Do Sales...

Is there a simple way to rename an Excel file that is used as a primary link to all formula references in another Excel File without having to redo all of...

I used to have month, day and year entered in separate columns on my ‘registrants’ sheet, when I did this I used this formula ...

Hello. I'm trying to find out if a cell value is on another sheet on my workbook. I'm using the VLOOKUP...

I cannot seem to view my vertical scroll bar. I've gone into my options and it is selected to view this but for some reason it's not showing. I can only...

Hello What is the max # of columns in excel by default? Is there a way to increase the # of columns Thanks

Keyboard and mouse cut and paste commands will not work in trying to copy a logo as a footer from Word to Excel

Hi: I have a pivot table in Excel 2007 where I have a date in the "Row Labels" section. I want to filter by a range of dates (rather than selecting each...

I've just upgraded to Office 2007. I'm trying to delete a column. I get that "cannot complete task with available resources" error. I then tried to delete...

I'm creating a row with drop-down lists with text.I want to create a simple drop-down list with yes and no. Yes would have a background (unseen) value of...

Hello. I'm trying to check if a cell value is found on another page of my workbook. I'm trying to use the VLOOKUP function

Hi, I have a list, "sponsor", with several names in it. I have rows of data where names appear in some cells (for instance, d1, e1, f1, g1, h1 have names)....

I have the following IF statement written into this cell: =IF(N6=1,O6,IF(P6=1,Q6,IF(R6=1,S6,IF(T6=1,U6)))) If cells N6, P6, R6 or T6 all have zeros...

When trying to print all 27 worksheets of a workbook the first worksheet lists there are 36069 pages. This is the same number shown if I go to Print Preview...

If i have a range of cells from A1:A100 and the same drop down list of names in each of those 100 cells how do i prevent staff from selecting the same name...

I am using Excel 2007 but cannot get the conditional formatting to work correctly. I have 100 rows of data. In the 1st row I need to fill the cell with color...

I have column A that has Account ID number and there are three sections. The I want to sort so that I have each section in order. In other words - see...

Is it possible to add a cell, say A2 which contains a number ($50.00) to cell A1 which contains a formula (=500-45-55-100) and the answer be a new formula...