Tips with spreadsheets (sheet) in Excel

In Excel spreadsheets to manage Excel data using Sheet tabs, you can easily add, delete, rename or customize the settings as you like for the worksheets in Excel worksheet.

Here are some basic tips when working with sheets in Excel you should know.

Add a new sheet

To add a new Sheet to work, click on the Insert WorkSheet icon (or the key combination Shift + F11 ).

Tips with spreadsheets (sheet) in Excel Picture 1

Right-click on the newly created Sheet and select Rename to rename the Sheet.

Tips with spreadsheets (sheet) in Excel Picture 2

Delete the sheet

When not using any Sheet, you just need to right-click the sheet name and select Delete to delete the Sheet.

Tips with spreadsheets (sheet) in Excel Picture 3

Change the size of the Sheet tab display

By default the tabs display small Sheet tabs, you can increase its size by the following actions:

Step 1: On the Desktop, right-click -> Personalize .

Tips with spreadsheets (sheet) in Excel Picture 4

Step 2: Choose Window Colo r.

Tips with spreadsheets (sheet) in Excel Picture 5

Step 3: Choose Advanced appearance settings .

Tips with spreadsheets (sheet) in Excel Picture 6

Step 4: In the Window Color and Appearance window , select Scrollbar in Item , edit the size in Size . Then click OK .

Tips with spreadsheets (sheet) in Excel Picture 7

The following results:

Tips with spreadsheets (sheet) in Excel Picture 8

Change the number of sheets displayed by default

By default, Microsoft Excel displays a maximum of 3 sheets when you open an Excel workbook. To change the number of default sheets, you can follow these steps:

Step 1: Select File -> Options .

Tips with spreadsheets (sheet) in Excel Picture 9

Step 2: In the General tab , enter the number of sheets to display by default in the box Include this many sheets in the When creating new workbooks section . Then click OK .

Tips with spreadsheets (sheet) in Excel Picture 10

Then you restart Excel, the default Sheet number will display exactly as you have set.

Change the sheet color card

Many sheets in an Excel file, you want to change the default color of the sheets to classify the sheets and make it easy to search. To change the default color, right-click on the Sheet you want to change color -> Tab Color -> Choose the color you want to change.

Tips with spreadsheets (sheet) in Excel Picture 11

You can choose More Colors to choose more colors.

Tips with spreadsheets (sheet) in Excel Picture 12

If you want to remove the color, select right -> Tab Color -> No Color .

Tips with spreadsheets (sheet) in Excel Picture 13

Copy the format of a sheet

With different data but the format of the sheets is the same, instead of having to format each sheet in turn, you can copy the format of the sheet.

Step 1: Select the Sheet containing the standard format that you want to copy to other sheets.

For example, select Sheet4.

Tips with spreadsheets (sheet) in Excel Picture 14

Step 2: Hold down Ctrl , then click on the Sheet to copy format.

For example: Sheet3.

Tips with spreadsheets (sheet) in Excel Picture 15

Step 3: Select File -> Print -> Page Setup .

Tips with spreadsheets (sheet) in Excel Picture 16

Then click OK , the format has been copied.

Tips with spreadsheets (sheet) in Excel Picture 17

Hide the workspace in Sheet

To hide a sheet, right-click on the Sheet you want to hide and select Hide .

For example, want to hide Sheet4.

Tips with spreadsheets (sheet) in Excel Picture 18

Want to display the hidden Sheet again, right-click any Sheet in Excel file and choose Unhide .

Tips with spreadsheets (sheet) in Excel Picture 19

In the Unhide table , select the Sheet you want to display again and click OK .

Tips with spreadsheets (sheet) in Excel Picture 20

Hopefully, with the above tips, you can manipulate more easily when working on the sheets of Excel spreadsheets. Good luck!