Dear All, In my excel file there are 20 to 30 sheets with the sheet names as Sheet1, sheet2, and so on. Is there is any way to go to sheet directly i.e if I...

Hello, I was wondering, how do I make an Excel sheet stretch so that there are no edges around it when I do a print preview? All the margins are set at "0"...

How can I assign a macro to a button? Can I create a new button and put it on the Quick Toolbar?

I have voluminous text of math expressions filled with subscripts and superscripts. I need to copy partial cell pieces into other cells containing the same...

Hi I have been using a computer programme for some research which exports data to excel in the format of hours:minutes:seconds:tenth seconds In order to...

When I edit a comment that I have previously entered in a cell (balloon autosized), I cannot see what I'm typing as I type/edit in the balloon. When I click...

Hi, when you export data from databases... often number fields are formatted as text. This is a problem, because sometimes formulas won't recognize the data...

I wanting D1 to show a name if there is a value grater than 0 in B. A 1,2 and 3 always stay the same. If B1 is grater than 0 D1 should say Brown. If B2 is...

Hi, I have a pivot table with payroll information. Right now weeks go across the top (column headings), and employees down the left (row headings). In the...

Hi, Hope you can help me, in the below pivot I have Countries in the column and in the column I have domestic/european/international category, asnd also...

Is there any way to "add" to my version 2003 Excel the ability to read .dat files?

I want the top of my window to look lilke all of the other windows (left-justified). Since upgrading to Office 2007, for some reason Excel and Word insist...

Any formula to convert entries like 123AAA456BBB AA12BB4567CCC to: AAABBB AABBCCC

I have exported Outlook Contacts to Excel. The data in the "BusinessStreet" field contains 'carriage returns'. I would like to non-manually split the data...

Can anyon epleae help? I have two coloumns of data, column B has approx 50 and column c has approx 40,000. I wouls like a formula or function to match if any...

a2..c2 are columns of numbers. a1..c1 are accounts. i want a formula in column d, beginning in row 2. the formula will return the value in row 1 and...

Can the INDIRECTfunction be used to create a multiple worksheet sum? The following formula works: =SUM(Sep09:Jan09!C9) I would like to change it to...

I have an Excel 2003 spreadsheet with 3 separate pop-up calendars, basically there is one at the top, one in the middle and one at the end. I used Ron de...

Dera Sir/mam, i'm working in a civil construction based on office excel so daily i use to type many numeric numbers in to alphabetic so i'm getting too late...