![]() ![]() I'd like to note that your post isn't actually the best in terms of spelling and grammar. (You would generally only do so, though, if it's that you need something clarified because of the grammar issue.) If there is a specific spot that you feel is unclear due to grammar issues, you'll want to provide more details on what is confusing you versus just saying "please publish without spelling, grammatical mistakes".Ĭhandoo doesn't have control over the grammar or spelling in users' responses such as yours, of course if that's what you're addressing, you should address your comment to the user who posted the item which you feel has poor grammar. Sri: The spelling and grammar are pretty accurate, if you're referring to the original article. More productivity tips & keyboard shortcuts.Save time & be awesome by double clicking in Excel.Do you know these Excel Productivity Secrets?.Excel Keyboard Shortcuts – a comprehensive list.Go thru the below stuff to one up your Excel mojo, seriously! So, naturally, we have a lot of articles on the same. I love keyboard shortcuts & productivity tricks. Time you can use to do other fun things like leaving comments on our website □ And if you do not use keyboard shortcuts at all, its about time you started. Go ahead and share the list of shortcuts you use everyday. You never know when aliens strike! What are the keyboard shorts you cannot live without? There is no point making something elaborate in Excel if you forgot to save. Just select any cell in a range of related data, and press CTRL+T to make it table. Tables are flexible, they can grow & shrink, they allow you to write readable formulas (structural references) and they are lovely. Nowadays, anytime I need to use a bunch of data, I convert that to a table and then use. CTRL+T – Insert TableĮver since I learned how to use Tables feature, I have never looked back. Type the destination URL or location and you are done. ![]() Select a cell or shape and press CTRL+K to launch hyperlink box. ![]() So I use them all the time, especially, if I have more than a couple of sheets. Hyperlinks make your work book accessible & pretty. Pick one and press ok to add it to the formula etc. Just press F3, no matter where you are (formula editing, conditional formatting, data validation etc.) and you get a list of all the defined names. But if I am making a dashboard or Excel model, I define several names and use them all the time. F2 – Edit a cellįor simple workbooks I do not use names. But whos got the time to carefully navigate between A and 2 and then type SHIFT+4? So I use F4 key and Excel changes the referencing style for me. You must pay it a couple of $s if you want to change the reference style from relative (A2) to absolute ($A$2). F4 – Change cell reference style while editing formulasĮxcel runs a pretty tight mafia when it comes to cell references. So I use ALT+ES (press E then leave the key and press S) to paste special. Often, I have to get data from other workbooks or clean the formatting of existing tables. ALT+ES – Paste Special > ValuesĬopying and Pasting is another must if you deal with data. Also, I use CTRL+SHIFT+arrow keys to select a group of cells 4. So I rely on CTRL+arrow key combinations all the time. When it comes to dealing with data, navigate, you must. CTRL+Arrow keys – Navigate around the workbook So I just turn-off and turn-on the filters, by pressing CTRL+SHIFT+L twice. So, Once I set a couple of filters, If I want to revert back to full data, I find clearing each filter a pain. Most of the time, I use filters to do ad-hoc analysis of my data. I use this all the time, to format cells, charts, text boxes – you name it. Oh CTRL+1, if I get an ear, every-time I press you, I would be a millionear by now. In this post, I am sharing 10 such shortcuts that I can’t live without, especially, when I am analyzing data, making charts and formatting my workbooks. So, it all boils down to memorizing the few shortcuts that you use all the time. While it may be a good idea to know a 97 different shortcuts for everything in Excel, the fact is, you don’t use them all the time. Everyone and their colleague knows the importance of Excel keyboard shortcuts. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |