Every time I open Excel, the Review Tool Bar is included at the top of the page. I right click, and uncheck the Review Tool Bar. However, it comes back every...

I have a case where I have a pivot table one ROW designator with about 20 values. I also have about 10 values. What I want to do is have the data listed...

I am looking for the command "don't print blank pages". I have a spreadsheet range 3 pages wide by 3 pages deep. I do not want page 2 and 3.

I have a large list of noames that I need to make sure that none of them are duplicated. Is there a way to have excel check it quisker than me reading every...

I know this is a bad design, but in my worksheet I want to sort using text entries (for example," dist" or "bp") that are (or may be) located in five separate...

Is it possible to select more than 2 options using custom auto filter? I have a worksheet filled with contact names and the cities in which they live and...

I can usually use my mouse to drag a page break to a new location in Excel in page break preview mode. But lately I have not been able to do this. When I put...

I want to set active cell highlighted in row & colmun cross as it was possible in Lotus 123. Is it possible? if yes, how is it?

WIN XO HE, XL 2002 SP3 Hi, every time I hit F1 within Excel, I am getting the following error message: "The window name "langrep" passed to HH_GET_WIN_TYPE has...

is there anyway I can apply a custom format to cells that can show either whole numbers, or decimals points e.g A1=15 A2=15.5 I would like this to be the...

I was given the array formula below to count the occurences of "12" & "11.5" in a column of...

Hi there! I need to set up an index page that will open other pages when a button is selected. How do I create this??

If I want to label worksheet by date for example, and I want the date to show in cell A1, how can I either have cell A1 produce the worksheet tab name,...

I need to import data into access from an excel spreadsheet daily. Currently I'm deleting to contents of yesterdays table then importing manually to get my...

Is there a way to have a workbook open to a certain worksheet regardless of which worksheet was active when the file was saved and clsoed? Example: Worksheets...

When I press left or right ... my cursur cell does not move from A1 to B1, but rather just my sheet view just shifts. Any suggestions? Is this a num lock...

When I go to FileOpen the Windows Explorer box will only let me see 1 file title at a time (for the currently highlighted file name). I need to scan 100's of...

I have a spreadsheet set up as so: Part #1 boss-1 X 125.2 125.2 126.2 Y 130.2 130.2 Z 125.5 125.5 boss-2 X 125.2 125.2 ...

I want to count how many numbers in a range are less than a given value. However, I don't want that given value to be hardcoded in the COUNTIF formula. For...

Good moring all, I'm trying to accomplish the following: file1.xls copy worksheet1 from file1.xls and then insert into file2.xls without overwriting...