Carpe diem: Excel Tips - From our readers

Excel tips will be taken from our discussions. 
Thank you smiley (Julie) for getting this started!
Send me any
tips you think others might be interested
in by C-mail or here:
Excel Forum
Connie (weeds)

Q. Do you know of any way, when I open the document, to go directly to the  
     worksheet I am looking for?

A. Use the arrows in the bottom left of the worksheet.  Right click on them and a  
of worksheet names will pop up.  Select whichever one you want.

 Q. I made a mistake and entered the same incorrect data many times in my  
  Is there an easy way to change that to the correct data?

A. In the Home Tab, editing section, click on Find and Select.  In the Find line
    enter the incorrect data (example: 10) and in the
replace line enter the
    correct data (example: 11).  Be careful as it will replace ALL the number 10s
    with 11, even if some number
10s need to be kept.  This works with
    words also.

Q. I want to highlight many rows to delete or work with but they are not
     consecutive.  Do I have to do each, one at a time?

A. You can highlight as many rows or columns as you like by holding down
     the Control key and clicking on the ones you want.  To highlight several
     that are consecutive, hold down the shift key, click on the first row you
     want, then the last row you want and all in between will be highlighted.
     Note:  this trick also works in email or any list on your computer.

Q.  How do I make the Column Headers print on consecutive pages?

A. In the Page Layout Tab, Print Titles, Sheet, click on rows to repeat at
    the top. A new window will open, click on the icon at the end of Row to
    Repeat line. Another window will open and i
n the actual spreadsheet,
    click on the row to repeat, usually number one containing the headers. 
    Click on the red X and then OK when the first window appears again. 
    This is explained with pictures in Printing Page.

« Return to Carpe diem

« Return to the Pages table of contents.

Carpe diem

This is a meeting place for people all over the world to discuss and share information about all areas of this ever shrinking globe. NEW!! I have added a forum for discussions about using Excel and tutorials in the PAGES section.

» Home
» Forums
» Articles
» Pages
» Links

Cubit owner: weeds

Admin team:

» Contact the admins

Want to browse around and see what other Cubits are about? Try the Cubit Finder