Renaming Sheets with out using Mouse

Renaming Sheets with out using Mouse

1) Make sure the first sheet is selected (it doesn’t matter what number is on it).

2) From the Format menu select Sheet and then Rename.

The name of the sheet will be highlighted so it can be changed.

Save Excel Data with Pipe separator

When saving a CSV file in Excel, it is really not 'Comma Separated'.It would be better to call it 'List Separator Separated' because it uses the list separator that is currently defined in the Control Panel's regional settings.

1. Start Excel and open the workbook with the sheet you want to convert.

2. Start Control Panel, Double-click Regional Settings, Click the Number tab

3. Change the list separator (it is probably a comma or maybe a semicolon before you change it) to a pipe symbol.

4. Click 'OK'

5. Return to Excel...

6. File - Save as, Type: CSV (Comma delimited). Click OK once or twice to accept the save.

7. After the save, go back to Control panel and set your list separator back to normal.