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
  • Three Must-Read Books for Corporate Bloggers Bloggers certainly love to read other blogs, but they also may be able to generate powerful resources from books on...
  • What's in a Name? There are three different primary considerations to make when it comes to naming your corporate blog. You cannot simply choose...
  • Change Focus How do you change the focus of the mind? Well, it is pretty simple. The mind is habitual, but it...
  • List Of All FIFA Players? Is there any way to get a list of all FIFA football players? I don't need it to contain any...
  • Tech Review of the iPhone 4 [/caption] By Jacqui Cheng The iPhone 4 is Apple's "biggest leap since the original iPhone," at least according to Steven...
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>