The problem I am having is when I open the workbook in question a message appears and states "The workbook you opened contains automatic links to information...

Hi, Just wanted to know if it is possible to have a command (Hyperlink etc.) return you back to the previous location (sheet)? Kind of like the Back button...

-- Lois Ann

Dear friends: I have two set of data only 1 & 0. and want to use countif function to choose those cells with only 1. my data is he 1 0 0 1 1 ...

I have several dates (in fact over 100) already entered in the Date column in "1 Jul 1854" format. This makes it impossible to run a meaningful sort by Date....

I want to select some rows from two different worksheet pages and have them print out on the same piece of paper ( I get one row printed out per sheet of...

how do i get the xml option in the data dropdown of excel 2003

Hi, How can I switch data between cells, rows or columns in one step? For instance, if I want to switch the contents of cells A1 and B1, how do I do that...

I would like to average the values in column B that lie between 2 values in column A. What I have so far is =average(if($A3:$A100, ...value in column A is less...

I created a book for creditcard management and I need only so much colums. How to delete the other colums? ervinke --

is there anyway you can see what links to other workbooks are associated with the workbook you have open. The problem i am having is when i open the workbook...

Hello, I have a spreadsheet and the top roll has information that I need to be able to see when I scroll down. How do I set it up so when I scroll down the...

Hi, In my worksheet, can I make a set-up that I can only go from 1 cell to another specific cell by just pressing the tab or enter key? like, in a...

Hello, Can I fill color a cell but will not show the color when i print it. thank you --...

I want to fill a standard size paper with 100 equal squares

I have office 2003 excel. There is no "Import File" commands in any of the menus. Is that normal or do I have something set up wrong? I have open workbook....

I need to open a new worksheet for a new year. (The year starts July 1st) I have copied the previous year worksheet to a blank worksheet in order to keep the...

Hi all. I am a new sole trader and I am looking for some template or something to assist me in keeping my books/accounts. I know very little about accounting...

hi, I am trying to modify the formula below to use the LEFT function.. any help...

I am new to VB and need to write an Excel macro that will check the other systems on a LAN in order to make sure they are alive and capable of accepting a...