Question about Microsoft Office 2003 Basic Edition English (s55-00066) for PC

1 Answer

Reading a excel file into progress

When reading a row I want to be able to tell if it is hidden.

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 407 Answers

You can select the entire workbook, using the blank grey box at the top of the spreadshheet between columns and headings - Right mouse click on the edge of the row and unhide.

Posted on May 22, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How to move the result of a formula up or down one cell


go google and type in --manual for excel version (what ever it is ) and down load the pdf file
go to a book shop and buy a Excel for dummies book
or e-bay and excel for dummies or other excel explained books
explaining it as a reply will be as confusing as the reply would be pages long

Oct 13, 2015 | Microsoft Excel for PC

3 Answers

How do i fix corrupted excel file?


It's a critical problem for us, after unfortunately data file got corrupt due to virus infection, I faced such type problem.
Read something useful herehttp://www.filerepairforum.com/forum/microsoft/microsoft-aa/excel/691-%E2%80%8Bhow-can-i-repair-excel-file
Or use Excel Repair Toolbox http://www.excel.repairtoolbox.com/

Feb 01, 2015 | The Business & Productivity Software

1 Answer

Doesn't remember there's a Header Row


You can try to select all data (except for the entire row which contain your header) and try to sort thru columns. This can sorted in ascending or descending order.

Jul 17, 2009 | Microsoft EXCEL 2004 for Mac

1 Answer

How to copy Excel worksheet in a word document?


go to Insert > File >select file and insert.
you have to select all documents when you when insert box opens.

Mar 15, 2009 | Microsoft Excel for PC

4 Answers

Excel file opens in read only mode


Hello,

There could be 1 of 3 things affecting this:

1. Is another application using that excel document? If so you will not be able to edit it until the other application stops using it.

2. Is the file currently in a location that you do not have write permissions? eg. another users shared documents

3. Check in the properties to see if it is set to read only. (right click on the document and click properties. in the 'General' Tab see if 'Read Only' is checked. If yes, uncheck it and click okay)

An easy way to make it editable providing you are the only one using it (If the above fixes dont work) open it up in excel and then click File --> Save As... and then save it somewhere else. That will then make it editable for you.

Have a Great Day!

Jan 28, 2009 | Microsoft Excel for PC

1 Answer

I have a year planner in excel in which first row consist of month jan,feb.... and in the second row days are there like 1, 2,3..... and on the very first column name of employees is there so my task is to...


There is always multiple solutions, but here is one...

Add a row (that can be hidden later if you want) where you have the full date (01/01/09). For this example it will be row "C." Then use Conditional Formatting with the function:

=weekday(C$2,2)>5.

See if this helps.

Jan 03, 2009 | Microsoft Excel for PC

1 Answer

HLOOKUP IN MS EXCEL


lookup value = value searched

table array = database

topmost row of lookup array must contain the data IDs and all IDs must be sorted in ascending order.

row index number = row number containing data to be shown; first row = 1

hlookup(x,tablearray,y) will look for x on the first row of the lookup table and return the value in the cell on the yth row

if formula cannot file exact x, it will look for the value closest to. but not greater than x

Nov 13, 2008 | Business & Productivity Software

1 Answer

Average handle time


I have created a spreadsheet for you to a) use and b) to learn from.

It is an Automated spreadsheet (as they should be) which calculates the number of minutes in a working week or month and calculates the average time per email giving Daily, Weekly and Monthly Outputs. It takes into account Public Holidays (or for time off). You can use the Output to create Graphs etc to visually display the Output.

It also allows you to calculate a Part Month average.

I have displayed it as it was CONSTRUCTED and as it would be USED.

The As Used worksheet is Protected and the only Inputs that can be done are in the Green Boxes (also the Saturday and Sunday boxes but you will need to Unhide the Validation List to include these and then to add 2 more columns titled Is Saturday? and Is Sunday? with the appropriate If Statement.

To unprotect the sheet go to Tools - Protection - Unprotect. There is no password so leave this blank.

All the workings are still there, the columns are just Hidden. To Unhide them, highlight the columns to the left and right of the hidden columns, click on Format - Columns - Unhide. To hide them again, highlight the columns that you want hidden, click on Format - Columns - Hide.

The LOGIC used (as in Functions) may seem complex but if you read the Descriptions in the first row you should be able to work out what and why it was done that way. Click on a cell to see what Function was used where.

You said that your spreadsheet was becoming a real mess, well I have created a monster for you (but not a mess).

I have uploaded the file to here:

http://users.tpg.com.au/lesliecl/

Hope this gives you the push to really start using Excel.

Apr 04, 2008 | Microsoft Excel for PC

1 Answer

Exel


Do you mean the numbers down the left side? If you are missing a row number, it may be hidden. Get it back with these steps:
Push Ctrl + A (selects everything)
Click Format, then Rows, then Unhide. The row number should be back now.
Hope that helps.

Feb 18, 2008 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Office 2003 Basic Edition English (s55-00066) for PC Logo

91 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18297 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...