Changing the name of a worksheet

The default names Excel uses for worksheets—Sheet1, Sheet2, and so on—aren’t very descriptive. If you don’t change the worksheet names, remembering where to find things in multiple-sheet workbooks can be a bit difficult.

That’s why providing more meaningful names for your worksheets is often a good idea. To change a sheet’s name, double-click the sheet tab. Excel highlights the name on the sheet tab so that you can edit the name or replace it with a new name.

Sheet names can be up to 31 characters, and spaces are allowed. However, you can’t use the following characters in sheet names:
: colon
/ slash
\ backslash
? question mark
* asterisk
Keep in mind that a longer worksheet name results in a wider tab, which takes up more space on the screen. Therefore, if you use lengthy sheet names, you won’t be able to see very many sheet tabs without scrolling the tab list.

Add to Technorati Favorites


// Related Posted - GOOGLE!

Loading



Related Websites
No comments yet.

Leave a comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>