Hide & Unhide: When you have many worksheets and wants to invisible one or couple of them in the workbook, you can hide any worksheet in a workbook to remove it from view. You can also hide the workbook window of a workbook to remove it from your workspace. The data in hidden worksheets and workbook windows is not visible, but it can still be referenced from other worksheets and workbooks. You can display hidden worksheets or workbook windows as needed. By default, all workbook windows of workbooks that you open are displayed on the taskbar, but you can hide or display them on the taskbar as needed. When you have a table of data with multiple columns and rows and if you are needed to get print out with certain columns and rows only, you can hide those rest of the columns and rows by using hide columns and hide rows tools which are unwanted to visible on the print out or screen of the window. How to hide selected columns? Select columns that you want to hide => Select Home Menu => Click Format Tool => Select Hide & Unhide => Click Hide Columns. For more understanding, look at the screenshot please: Rename Sheet: In MS-Excel 2016, At the bottom of worksheet window is a small tab that indicates the name of the worksheet in the workbook. Excel names this worksheet using a default name. This name (Sheet1) is not very descriptive; you might want to rename your worksheet to reflect what they contain. For example, when you need to use more worksheets in one workbook, you can insert more and use them. And if your workbook contains your budget plans for the different projects, each worksheet within the workbook might contain budgets for individual projects. When you have more sheets in a workbook, in-order to your data you can rename every single sheet with different names as needed. How to rename a sheet to “PKMV”? Keep cursor point in the sheet that you want to rename => Select Home Menu => Click Format Tool => Click Rename Sheet => Type a name “PKMV” and then press Enter Key. For more understanding, look at the screenshot please: Move or Copy Sheet: Whenever you need to change the location of the sheet in the workbook, you can use the Move or Copy Sheet command to move or copy entire worksheets (also known as sheets), to other locations in the same or a different workbook. You can use the Cut and Copy commands to move or copy a portion of the data to other worksheets or workbooks. How to move location of the current worksheet to the end of the sheets? Select Home Menu => Click Format Tool => Click Move or Copy Sheet => Select Move to End in the box => Click OK. For more understanding, look at the screenshot please:
0 Comments
|
Archives |