When viewing a spreadsheet and I click on a cell, all text in the cell shows up in the box at the top of the screen but all of the text doesn't show up on...

I take my medicine for diabetes three times a week, every other day, MWF. Sometimes my blood is drawn on the first day, sometimes the second day, and...

Hi guys I need to know how I can format cell such that when I enter a 6 digit number such as "035891", it will be displayed as "S(035891)" instead. So...

Posted about this a few times but with no explanations, so i can only put this down to the supernatural Everytime I try to print using Microsoft Office...

I want to use Countif with 2 conditions. For example, 1. It searches for the Emp Name, I need - Emp Name column A 2. It checks whether the Emp is Absent /...

Test Post

I Have a sheet with store and Region Store coloum has unique value and each store number will show in only one Reg (Reg1, Reg2, Reg3, Reg4 or Reg5) for...

I have a alphanumeric list as - FM2130 FM613 FM3126 FM10 FM76 FM4120 I need it in an order as -

Column A is a list of dates with the format 01/01/2000, 30/04/2001 etc. How would I count the number of occurrences of dates in column A for the month of say...

I have designed a document with 1200 lines that have been formatted. Some of the users will have only 20 lines, but some will have 1000. I would like them to...

All I could get it to do was average 3 weeks grades instead of the 6 weeks I put in for (from G1:M1) and by highlighting the whole area-I used the...

i have eight sheets in a worbook---they have headers, footers, row heights, column widths, font sizes, etc. can I format these so that everything ...

Excel 2007, Vista How can I make the pivot table update automatically when the underlyng data changes? (F9 doesn't force an update.) Also, how can I add...

I have 20 students with 6 grades entered for most of them-How do I average them? -- sally nbct '02

how do I copy a formula in a column through 52 rows? I have a column of 52 rows into which I want a sum from about 10 other column's cells to appear. How do...

I'm trying to copy a table from a website to an Excel 2003 spreadsheet so that the results are listed in a single line for each nursing home listed. When I...

Due to a print formatting issue I am trying to copy the contents of one cell to another. If the original cell is blank, I want the duplicate cell to be...

For print formatting purposes I need to duplicate a keyed in numeric value from one cell (say A4) into another cell (say Z4). In many cases the original...

im a principal and im trying to figure ou how to make a transcript