Conditional formating to highlight problems.

Question moved to a better category.

Some of the rows or columns in my spreadsheet are hidden. How do I see all rows or columns?

1. Select the area of the spreadsheet where rows or columns are hidden. To select the entire spreadsheet, select Edit ? Select All from the main menu or press CTRL + A
2. To show all rows, select Format ? Row ? Show from the main menu
   To show all columns, select Format ? Column ? Show from the main menu.

https://www.google.com/search?q=unhide+a+hidden+row+Lotus+123

..

To add commas to your spreadsheet you need the format the numbers. If you want your whole spreadsheet to use commas, click on the area to the left of column A and above number 1. This should highlight the whole spreadsheet. Click on the "," icon in the "number" area, and your spreadsheet will be formatted to put commas in.

Good luck,

Paul

One way would be to create a colunn C and use the formula: =COUNTIF(B$2:B$200,A2) in cell C2. Then copy the formula down to C200. (assuming you have 200 entries in B...). This will put a "1" next to every number in Column A that has a match in column B. Then you could put a conditional formula in column A that will highlight the cell if the value in column C is equal to 1. Alternatively you could also simply filter for 1's in column C and then manually highlight the cells that show up in A!

option: formula is
formula: =(datecell="")
select formatting of choice

Highlight the order cells, go to >format>conditional formatting, choose "formula is" instead of "cell is". When you refer to the datecell, use the first date cell in the column only, and do not use $ signs.

Here is a solution that might work for you. Please be mindful that there are several different solutions that will achieve the same thing in Excel (I am assuming Excel is your software).

1) Make sure each column in your spreadsheet has a heading.

2) Highlight (select) the column of birthdays.

3) Choose Format from the menu bar.

4) Choose Cells... from the drop-down menu.

5) For the "category", choose Custom.

6) In the "type" box, type yyyy

7) Click OK and when you return to your spreadsheet, you will see only the years displayed. However, when you try to edit a cell, you will see that the entire birth date is stored and preserved.

8) Now, highlight the entire table

9) Then, choose Data from the menu bar

10) Choose Subtotals... from the drop-down menu

11) In the "At each change in" box, choose the name of the column with the birth dates

12) In the "Use function" box, choose Count

13) Leave all other choices at their defaults

14) Click OK, and you are done.

Using this method, you can continue to enter the data as you always have. In that way, the birth date info is never actually destroyed or converted. What you are doing is simply deciding what is displayed.

I hope this helps.

You should tell us your "Operating System, Spreadsheet Program and Printer" for us to give you a difinitive answer. Whithout this info I will attempt to give you a general answer.

In your spreadsheet program, go to "File" and select "Page Setup" and set your paper size and set your margines and Portrait/landscape option. Your spreadsheet display should show you the paper limits for printing each page. Adjust the columns to the paper size. Highlight all the columns and rows you want to print. Find the menu option to set print area and click it. Now the computer will send the paged information to the printer and print as many pages as needed to cover the print area.

to unhide th column.
click on the upper most left corner (the box on top of the row1 and column c). the enter spreadsheet should be highlighted. then go to format>>unhide. you should have the column A and B.
as far as the lost numbers. if you did not close the work sheet, you can retrieve them by using the back button on the tool bar. you can't retrieve lost number if you close the worksheet and reopen it again.

conditional formatting is alright.

you just have to remove the $ signs in the cell reference when you set a condition.

then, copy-paste

go to page setup and under scaling you can adjust to your required percentage

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.