Well, that trick and a lot more in my book, Then arrow to rename and type whatever you need to type. Basically, from the sheet, F6, and then Shift+F10, and Those of you that are hardcore keyboard shortcut people, you now have a way to There and then F6 will take me back where I am- It's called the F6 loop. Press F6, and then F6 again will now take me over to the other window to get So right now I'm over on the left hand side, press F6,ĭown in the sheets press F6 over in the taskbar press F6 down in the bottom But if we actually had a Split window here, then the F6 Loop Something that I never use in Excel, that's called the Split window- I hate Shortcuts, and then, finally, F6 again goes back to the sheet. And then I press F6 again and it goes up to the keyboard Start actually recording a macro or go to Page Layout view, or Increase orĭecrease the zoom. Where am I now? Check this out, lookĭown in the bottom right-hand corner of the screen- that status bar- so I could Go to the other task pane, press F6 again. Task panes- so, right now, I'm in pivot table fields- press F6 again, and I So you start out here in the spreadsheet, press F6, you goĭown to the sheet tabs like that, Press F6 again, and you go to one of the open Nope, I won't go to that-Īlright, so the F6 Loop, let's see what else Will open the menu outside of your screen, down here to Insert, Delete, Rename,Īnd then I can type something else like Sheet1. Program key, and Ctrl- I can press that, or if you don't have that, Shift+F10 Side, Spacebar, Alt, and then the little right-click key that's called the Press the Program key- now, on my big Desktop keyboard here, on the right hand Now that I've selected that, I can either I press the right arrow key, I go over to BuyTheBook, TakeTheCourse, WrapUp.Īlright, so I've now selected that. To stop is right down there- see Podcast Content has now been highlighted- if Stop- and this is new, it never used to do this- the first place we're going We're going to go for a ride on a loop and the first place that we're going to Right now, you see that I'm up here in the spreadsheet, and when I press F6, We're going to ride something called the "F6 Loop"- F6. There to change the sheet tab without the mouse. Now says Podcast Content, it doesn't show up in the accessibility checker- so,Īgain, the whole trick is how do we get down Open that drop-down box and I would be able to rename the sheet. Here and I can go to the one that says, Hey, you have a bad Sheet1, and I could Sheet1- then Alt+R for review, +A1 for check accessibility. If that didn't say Podcast Content- if it said Yeah, now if you watched yesterday's podcast, I know keyboard shortcuts for everything, but I don't I want you to rename that sheetĭown there at the bottom of your Excel spreadsheet without using the mouse. Jelen, and I got a challenge for you today. Hey, welcome back to MrExcel netcast, I'm Bill If you like what you see in this video, please You can use the F6 loop to get to Page Break Preview, or the Zoom or Record Macro, but all of those can be accessed from the Ribbon, so it is not a big deal. Shift + F10 to choose more of the status bar statistics. Press the F6 loop until the status bar is selected. It is interesting that other items in the F6 loop can be accessed with keyboard shortcuts. Once the tab has focus, use Shift+F10 or the Program key to access the menu Once you have a sheet selected, you can press Shift + F10 or the Program key to open the right-click menu. A thin green line appears at the top of the sheet tab: Press F6 to move focus to the sheet tabs. Here is the sheet tab for Podcast Content while a cell is selected: If I lose track of where I am in the F6 Loop, I find pressing the arrow keys might subtlely change something and I can see what is selected. When you press F6, if you don't know where to look, you won't know what to look for. Now, hey, look… this is all super subtle. The status bar at the bottom of the screenĪ cell or cells if you have Split Window applied When you press F6 repeatedly, focus moves between the following objects: There are no web pages dedicated to the F6 Loop. Sometime in the last year, for Office 365 customers, the Excel team added the Sheet Tabs to the "F6 Loop". It definitely was not working in Excel 2013. I think this was impossible until recently. Thanks to Essem, José Mauricio Flores, Bharat Dhami for posting this easy workaround at YouTube. Many people on YouTube pointed out a far simpler method: Alt, H, O, R.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |