Showing posts with label Other. Show all posts
Showing posts with label Other. Show all posts

6/27/2013

How to Rename the Worksheet in Excel?

How to do in Excel? Change worksheet name. How to Change the Name 
of an Excel Worksheet?

Default names of Excel worksheets:

Sheet1, Sheet2, etc. 

To rename a sheet you have to double click its tab. Excel highlights the worksheet name, so that it can be modified or replaced with a new one.


Change the name of the worksheet in Excel
Rename Sheet - Excel 2010 Screen

Sheet name can contain up to 31 characters, including spaces.
You can not use characters: / \ [] <>. ? '*


6/26/2013

Numbered list in Excel - How to make?

How to do in Excel? numbered list How to create a numbered list in Excel?
How can you generate a list of numbers
in Excel ?

  • Mark in the Excel spreadsheet cell A1, and type 1, then cell A2 and type 2,
  • Select area A1: A2,
  • Move your mouse to the lower right corner of the selected field - square (fill handle)

How to do in Excel? numbered list
Excel 2010 Screen

  • Click in the box left mouse button and drag vertically down to cell A10,
  • Excel automatically enters the numbers in the selected area when the mouse button is released - will increase the value in the next cell on the difference between the numbers in cells A2-A1, etc.

How to do in Excel? numbered list
Excel 2010 Screen


Video tutorial:


Popular tutorials