How do I select multiple sheets in excel using the keyboard?



How do I select multiple sheets in excel using the keyboard?..

Answer / Kalpna Sharma

To select multiple sheets using the keyboard, you can hold down the CTRL key and click on each sheet name. Alternatively, you can also select the first sheet, then use the shortcut ALT + <number of the desired sheet>. Here's how it works:

1. Press and hold CTRL
2. Click on each desired sheet while holding down CTRL
OR
3. Select the first sheet
4. Press ALT and the number corresponding to the desired sheet (for example, ALT + 2 for the second sheet)

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

What is what if analysis scenarios excel?

1 Answers  


What is the default file format for excel 2016?

1 Answers  


I want to add 25 to all of the cells in column a. I do not want a new column, I want to add it right to the cells in column a?

1 Answers  


How do I format a table in excel?

1 Answers  


I am using excel, and want to create a line graph with the data on my spreadsheet, ranging from january to december. However, I don not want the empty cells to berepresented as zeroes in the line graph. Is there a way to graph all months without displaying the zero values?

1 Answers  


What is a tab in excel?

1 Answers  


What is merge and center in excel?

1 Answers  


How do I write a formula in excel?

1 Answers  


How do I use text in excel?

1 Answers  


What are slicers in excel?

1 Answers  


How do I limit a value in excel?

1 Answers  


How do I change the default font in excel 2007?

1 Answers  


Categories