excel keyboard shortcut for switching sheets mac

Excel Keyboard Shortcut For Switching Sheets How To Get The

When you purchase through links on our site, we may earn an affiliate commission.

While Google Sheets offers standard shortcuts for actions like copy and paste, it also has more powerful key commands that let you insert and delete rows or change how it formats numerals.

You can unsubscribe at any time and well never share your details without your permission.

Like this one client, who didnt believe me when I said I can actually move the tab using just the keyboard.

He was pretty blown away, and hopefully, in this video, Ill elicit the same reaction from you.

If you hit H its going to move there, if you hit to the O its going to move to Format, and if you hit M, its going to give you the Move or Copy window.

I can use the mouse to click, or I can go up and down with the arrows.

If its actually not in this focus, Im going to hit TAB to move to the next option.

You can also hit SHIFT TAB to move prior, so TAB will go forward, SHIFT TAB will go backwards.

Im going to move this cover sheet right before the number six.

I want to rename it.

ALT H O R. Its already highlighted, all I have to do is start typing and hit ENTER, and Im good to go.

So, you see how its underlined here with the C That means if you hit ALT C, it will give you that checkbox all ready for you without having to lift a finger, which is awesome.

You can enter, its going to create that duplicate in the position that you want, so really, really helpful.

Excel Keyboard Shortcut For Switching Sheets How To Get The

If you want to hurry over and rename your sheet, thats how to get the rename option, and then the C, copy.

Youre actually better off copying sheets this way, as opposed to selecting all and copying, and then going to a blank sheet and pasting it in.

Instead, you want to do ALT H O M, and then create that copy this way.

Always save backups of your work and create a new version if you dont want to have anything go wrong, but essentially, thats what you need to do.

So, theyre already set up with numbers, its pretty straightforward.

Then rename them all in all caps, and then create a copy of all of them, except for the cover.

The next time youre spending quality time with your family, and youre in front of that roaring fire, and youre sharing stories of how it once was, make sure that one of those stories shares the Excel love.

Built with Make. Your friendly WordPress page builder theme.

Excel Keyboard Shortcut For Switching Sheets Mac