Essential Spreadsheet Shortcuts Every User Should Know

The top 4 Spreadsheet shortcuts for increased productivity   

     Discover a faster and more efficient way of working in Excel sheets and other spreadsheets with these essential shortcuts. Learn how to navigate, format, and streamline your work with ease, including tips on creating links between cells.  

          

      1.     How to count spreadsheets

2.     How to list out sheet names automatic

3.     How to select  spreadsheets in one click

4.     How to make link between spreadsheets

1. How to count spreadsheets

Open one new sheet and apply below formula in any cell then respective workbook sheet count will be displayed.

=sheets()

   Example : 

•     For your workbook insert one sheet or existing sheet itself you can do the below.

Ø  Type below formula in any one the cell

  Ø   After entered formula click ender then it will show you the count. This count includes the new sheet which I opened so total sheets in this workbook is 14

2. How to list out sheet names automatic

  Ø  Go to formula then click Name Manager -> NEW -> under Name Type “List sheets” -> under Refers to type below formula then click ok.

 

=REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"")

  Ø  Click ok then below window will show just click close. 

    Note: Which ever workbook you have to know the sheet name automatic then you must do the same this process. 

From the new worksheet enter 1 in cell A1 then 2 in cell A2 so on like below Then Cell B1 Type this formula

 “ = Index(Listsheets,A1)” then click enter automatically sheet name is appear like below

Note : 

 Ø  Number should be available in Cell A otherwise name not appear while tracking in cell B

 Ø  Suppose number not appear in cell A below kind of error will appear

3.  How to select work sheets in one click

Suppose our workbook if its available more number of worksheets then how we can select work sheet that only we are going to look in this session.

Press “Ctrl + G” then below window will open -> click worksheet which you want to view -> then press ok

4.  How to make link to spreadsheets

     Right click sheet name -> Click Link

 

Below window will show then select respective sheet “Summary” then click ok

   Then it will show link like below. Once you click this link then respective worksheet will open.