Home

Favorite feature or tips / tricks you use in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-451554%22%20slang%3D%22en-US%22%3EFavorite%20feature%20or%20tips%20%2F%20tricks%20you%20use%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-451554%22%20slang%3D%22en-US%22%3E%3CP%3EGeneral%20conversation%20starting%20question%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20just%20wanted%20to%20gain%20a%20sense%20of%20any%20features%20or%20tactics%20that%20you%20employ%20in%20Excel%20that%20make%20the%20tool%20more%20powerful%20for%20you.%20For%20example%20I%20always%20like%20to%20make%20sure%20my%20rows%20and%20columns%20are%20distributed%20evenly%20both%20vertically%20and%20horizontally%20(when%20possible)%20to%20provide%20a%20clean%20view%20for%20anybody%20reading%20my%20data.%20I%20find%20this%20really%20makes%20it%20easier%20for%20consumers%20of%20my%20work%20to%20read%20whatever%20it%20is%20I%20am%20presenting.%20Another%20thing%20I%20always%20try%20to%20do%20is%20use%20hotkeys%20whenever%20possible.%20I%20consider%20it%20a%20personal%20failure%20when%20I%20have%20to%20use%20the%20mouse.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20are%20your%20favorite%20Excel%20tips%20or%20tricks%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-451554%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-452469%22%20slang%3D%22en-US%22%3ERe%3A%20Favorite%20feature%20or%20tips%20%2F%20tricks%20you%20use%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-452469%22%20slang%3D%22en-US%22%3EIf%20it%20looks%20like%20a%20table%2C%20format%20as%20table.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-452620%22%20slang%3D%22en-US%22%3ERe%3A%20Favorite%20feature%20or%20tips%20%2F%20tricks%20you%20use%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-452620%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F122143%22%20target%3D%22_blank%22%3E%40Daniel%20Courtney%3C%2FA%3E%26nbsp%3B%2C%20that%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.tandfonline.com%2Fdoi%2Ffull%2F10.1080%2F00031305.2017.1375989%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.tandfonline.com%2Fdoi%2Ffull%2F10.1080%2F00031305.2017.1375989%3C%2FA%3E%26nbsp%3Bis%20recommended%20reading.%3C%2FP%3E%0A%3CP%3EAs%20for%20shortcuts%2Fmouse%20I%20don't%20thing%20we%20shall%20avoid%20one%20or%20another%2C%20it%20depends%20on%20tasks.%20Reasonable%20combination%20works%20fine.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-452990%22%20slang%3D%22en-US%22%3ERe%3A%20Favorite%20feature%20or%20tips%20%2F%20tricks%20you%20use%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-452990%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%20I%20agree%20on%20the%20kbd%20vs%20mouse%20debate%3B%20some%20things%20are%20pretty%20much%20undoable%20using%20just%20the%20keyboard.%20But%20many%2C%20many%20operations%20in%20Excel%20are%20way%20more%20efficient%20if%20you%20learn%20the%20keyboard%20short-cuts.%20My%20favorite%20one%20is%20control%2B1%20to%20bring%20up%20the%20format%20dialog%20for%20any%20selected%20object%20in%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-453038%22%20slang%3D%22en-US%22%3ERe%3A%20Favorite%20feature%20or%20tips%20%2F%20tricks%20you%20use%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-453038%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%2C%20yes%2C%20sure%2C%20shortcuts%20are%20quite%20efficient%2C%20especially%20for%20the%20routine%20and%20day-to-day%20operations.%20I'd%20only%20like%20to%20say%20what%20the%20approach%20only%20shortcuts%20or%20only%20mouse%20is%20not%20productive%20from%20my%20point%20of%20view.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20for%20my%20ones%2C%20first%20in%20mind%20and%20more%20often%20used%2C%20perhaps%20Ctrl%2B1%20(of%20course)%2C%20Ctrl%2BT%2C%20Ctrl%2BPgUp%2FPgDn%2C%20Ctrl%2BD%2C%20Ctrl%2BShift%2BUp%2FDn%2C...%20Majority%20of%20them%20are%20Ctrl%2B%20or%20GrCtrl%2B%2C%20and%20I%20prefer%20mouse%20instead%20of%20something%20like%20Alt%2BA%2BB%2BC%3C%2FP%3E%3C%2FLINGO-BODY%3E
Daniel Courtney
Senior Member

General conversation starting question here.

 

I just wanted to gain a sense of any features or tactics that you employ in Excel that make the tool more powerful for you. For example I always like to make sure my rows and columns are distributed evenly both vertically and horizontally (when possible) to provide a clean view for anybody reading my data. I find this really makes it easier for consumers of my work to read whatever it is I am presenting. Another thing I always try to do is use hotkeys whenever possible. I consider it a personal failure when I have to use the mouse.

 

What are your favorite Excel tips or tricks?

4 Replies
Highlighted
If it looks like a table, format as table.

@Daniel Courtney , that https://www.tandfonline.com/doi/full/10.1080/00031305.2017.1375989 is recommended reading.

As for shortcuts/mouse I don't thing we shall avoid one or another, it depends on tasks. Reasonable combination works fine.

@Sergei Baklan I agree on the kbd vs mouse debate; some things are pretty much undoable using just the keyboard. But many, many operations in Excel are way more efficient if you learn the keyboard short-cuts. My favorite one is control+1 to bring up the format dialog for any selected object in Excel.

@Jan Karel Pieterse , yes, sure, shortcuts are quite efficient, especially for the routine and day-to-day operations. I'd only like to say what the approach only shortcuts or only mouse is not productive from my point of view.

 

As for my ones, first in mind and more often used, perhaps Ctrl+1 (of course), Ctrl+T, Ctrl+PgUp/PgDn, Ctrl+D, Ctrl+Shift+Up/Dn,... Majority of them are Ctrl+ or GrCtrl+, and I prefer mouse instead of something like Alt+A+B+C

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies