You can also select any cell in a range of related data, and pressing Ctrl + T will make it a table.įind more about Excel tables and their features.Īutocomplete the function name. Insert the contents of the Clipboard into the selected cell(s). Save the active workbook under a new name, displays the Save as dialog box.Ĭopy the contents of the selected cells to Clipboard.Ĭut the contents of the selected cells to Clipboard. The Ctrl and Alt keys are located on the bottom left and bottom right sides of most keyboards. Note for newbies: The plus sign "+" means the keys should be pressed simultaneously. Still, let me write them down again for beginners. I know, I know, these are basic shortcuts and most of you are comfortable with them. Must-have Excel shortcuts no workbook can do without Must-have Excel shortcuts no workbook can do without.If you want to re-arrange the shortcuts to your liking or extend the list, then download the original workbook. Also, you can download top 30 Excel shortcuts as a pdf file. I've put together a list of the most frequent shortcuts below. Each new version of Excel came with more and more new shortcuts and seeing the full list (over 200!) you may feel a bit intimidated.ĭon't panic! 20 or 30 keyboard shortcuts will absolutely suffice for everyday work while others are purposed for highly specific tasks such as writing VBA macros, outlining data, managing PivotTables, recalculating big workbooks, etc. I’m an avid bird photographer and traveler-I’ve been to 40 countries, many with great birds! Because I’m also a classical fan and former performer, I’ve reviewed streaming services that emphasize classical music.Microsoft Excel is a very powerful application for spreadsheet processing and a pretty old one, its first version emerged as early as in 1984. I’ve attended trade shows of Microsoft, Google, and Apple and written about all of them and their products. Prior to my current role, I covered software and apps for ExtremeTech, and before that I headed up PCMag’s enterprise software team, but I’m happy to be back in the more accessible realm of consumer software. I was privileged to byline the cover story of the last print issue of PC Magazine, the Windows 7 review, and I’ve witnessed every Microsoft win and misstep up to the latest Windows 11. I’ve been reviewing software for PCMag since 2008, and I still get a kick of seeing what's new in video and photo editing software, and how operating systems change over time. PC hardware is nice, but it’s not much use without innovative software. Windows Key-E opens the File Explorer and is another key command that I plan to use more often since I need to open that utility many times per day. After all, pressing one key is as simple as it gets, and how often do I open the Start menu? (Often.) Its close relative is Windows Key-S (or Windows Key-Q), which opens the Search panel where you can search your PC as well as the web. I must confess that I don’t use this darn-useful keyboard shortcut much, but I plan on changing that. You can remember it as the I standing for information. The Windows 11 interface makes access to this somewhat less prominent than Windows 10 did, so using the keyboard shortcut can alleviate that. Windows Key-I opens the Windows Settings app. It’s useful for a business or public environment where you don’t want to leave your computer open for anyone to see or use but you don’t want to shut it down completely. Pressing Windows Key-L simply locks the PC to the lock screen. For more on gaming in the new OS, read Jordan Minor's piece, With Windows 11, Microsoft Makes Every PC an Xbox. It can be useful even for nongamers like yours truly. It offers a bunch of controls and displays for things like performance, audio settings, friend activity, and screen recording. To see the Xbox Game Bar, use the keyboard shortcut Windows Key-G.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |