I have a button linked to a simple macro which steps through each page in the active workbook, returns the zoom level to 100% and the cursor/ active cell to the top left cell and finishes with the active sheet being the first sheet in the book and the cursor/active cell as A1. It really useful to leave a workbook tidy for someone else to pick up.
1. Freeze panes 2. Filter Toggle 3. Format Painter 4. Sort Asc 5. Sort Desc 6. Auto Sum 7. Borders 8. Page Set Up 9. Print Preview (new) Thank you for this video. I like the idea for adding the Dollar Sign. Adding Dollar Sign & Power Query shortcuts today. I also added Draw Horizontal Text Box because I usually copy & paste a user's exact request from an email onto a sheet in the workbook. CYA.
Why couldn't I have found you months ago? The QAT would have saved me so much time in reformatting my companies documents (they were in bad shape). The organizational\project management tools I have created using tools and techniques I learned from you have helped us out tremendously. You have been so helpful. Thank you!!
You are an angel in disguise. I’m so glad you’re doing what you’re doing. Thank you!! You are awesome don’t ever believe anyone who tells you otherwise
I have been watching your videos for awhile now. I think that I am one of the more excel-experienced employees at my workplace. However the amount of stuff I am learning from your videos is insane. Honestly your videos are the only ones I check on youtube regularly. Keep up the fantastic work!
Sorry ... my QAT is a bit boring. It is limited to the 'basics', i.e. Save, Undo, File Open, Print Preview etc. But no surprise, you have once again provided me with several ideas. As usual, I will re-watch again ... and again ... to better understand the possibilities (and accompanied with another cup of coffee ... and a few Christmas cookies ... ) FYI ... my only internal rule is the QAT must always be located BELOW the Tool Bar. PS at the 12:25 mark "... Thank you for being here ... ". HA! ... I think that is MY comment to YOU! Your videos are a standing calendar-date first thing every Thursday morning. Wishing you the best for 2022.
Yes! Thank you! QAT is the .no. 1 thing I recommend to other accountants on ways to improve speed & efficiency. 1: Format Painter, 2: save, 3: insert row, 4: delete row then many many more.
Few QAT items that i found useful are: 1. Trace Dependents; 2. Decrease decimals; 3. Auto Filter. Out of these, Auto Filter is my favourite, because it automatically applies filter on the item where the cursor is, with only a click of a button.
I’m a BIG fan of the QAT. I pronounce it “CAT” since there is no “u” after the “q”. And if you put the QAT below the ribbon you not only get color icons, you also have a lot more real estate to put icons on it. It’s a long walk from left to right, that is why in that configuration I call it the QAT walk. Easy to pronounce, easy to remember. My QAT walk is completely filled from left to right, I regularly clean up if I want to add a new favourite button, because I need to see all my buttons on the QAT at one glance (otherwise you forget about it anyway). As you know the first 9 positions on the QAT are hotkey positions, so care needs to be taken in determining which buttons to put there. Here is my top 3: “Launch Power Query Editor” (ALT+1), “Launch Power Pivot Editor” (ALT+2), “Paste Values [only]” (ALT+3). Users don’t like having to remember shortcuts, but pressing a button on the QAT is a-OK.
Hi Leila My favorite is "clear all filters" as I get many pages wide sheet whare it is sometimes too much investigation to find al the set filters by browsing.
Is there a way to adore a video instead of just liking it? I've been using the QAT for 20 years now and I still learned a couple of new and really cool things here. Thank you, Leila!
Really your videos are more than Excellent Many thanks for your great efforts for conveying these wonderful lessons, explanation and knowledge to all people who interested to get advanced skills. Many thanks again. Merry Christmas to you and to those who read this comment
Thank you again Leila! Great time-saving tips. I did not know about the separators that can be added to help organize. Also did not know there was this cool Camera feature! Once again, I ALWAYS learn so much from your wonderful videos!!! Thank you!! Wishing you a Happy New Year !!!
Great topic! I use copy/paste values only EVERY day as ALT 7 (this is my copy) and ALT 9 (paste values only). I also have add/remove filter, clear filter, queries and connections, launch Power Query, and launch Power Pivot window. Things I'll be adding because of your video-full screen print preview, and the new measure. Thanks!!
and Camera - wow! Select Visible Cells and custom macros are my favorites. Multiply items by negative 1; change debit to credit and credit to debit; concatenate 3 cells into one in 4 columns; date/time stamp; filter by 2 of our cash accounts. Thanks for the video.
OMG! Super helpful. The camera feature is the best thing since sliced bread. Thankfully I have a full-size keyboard to protect the coffee input system. I love your teaching style. Thank you for all the content you post. It is very generous of you to let us have access to so much valuable information.
One that I absolutely recommend, Auto filter... It can automatically filter a range with value of your selected cell, with just 1 click! I use it a lot, specially when sharing screens with higher ups, always leaves them confused as to how I did that! 😂
As an English teacher, I sometimes use excel to create materials and documents like appendixes and lists. Therefore the merge cells, wrap text, and text to columns are useful to me.
I just bought MS Office 2016 for the half price of Office '21 and got upgraded from my old 2007 version. Now I'm looking forward for a great practice with your videos!
I mostly use keyboard shortcuts, but have found that the QAT is a great way to pin four useful macros for fast access: 1 split text into columns by comma, 2 split text into columns by semicolon, 3 switch off system separators (which for me means use the English decimal point), and 4 switch to system separators (which for me is decimal comma). This means I can paste a csv from any external txt source and pivot the numbers in no time.
Great video! I've used a personalized QAT for years. I also use a custom ribbon in conjunction with the QAT. If you position the ribbon in front of the Home ribbon, it becomes the default ribbon.
Thank you Leila for covering this topic! My QAT has Paste Values, Clear All, AutoFilter, Clear Filter, Camera, Wrap Text, Pivot Table and Pivot Chart Wizard, Spelling, Expand Field, Select Objects, Manage Rules, Print Preview and Print and Accounting Number Format buttons. This QAT helps me in my regular work via the Alt shortcuts, really useful! I will also think of adding Macros now!😊👍
Nice! Instantly added Camera and the legacy Print Preview to mine! I wish MS added a search field box in the Add commands box. It'd be much easier typing 'Paste' there and see every command containing that word.
Leila, as always, it was a video with very useful information. Congratulations. What I can add, in addition to this information, is that it is very useful to use our own customizations only for this workbook or for all workbooks option in the quick access bar we created. This prevents other users using Excel from seeing the confusing shortcut commands when they open the same workbook. In addition, it is very tempting to add an import/export option to the quick access options that these shortcuts can be exported from excel, saved to the computer and saved as an add-on to other applications of the office program.
I use the (Dutch version of) switch to another workbook and of course the good old camera. Besides that I like to have the Alt-11 (show VBA) button there. I also like to use tha Save button and the Print Preview. I like your tip about the two different possibilities of print tpreview. And the last one I have is the Filter button. I fullt agree with the desire to have a full-functioning alternative to the F4 key! Thanks for yet another graceful tutorial. 🙂
Thanks a lot Leila for ur valuable videos, a lot of new and inspiring details as usual Well I don't know what to mention and what to skip, I will add all, I hope this would be useful for anyone Set print area Print preview full screen Freeze pans Edit links Past values then formatting then formulas then link Trace precedent then dependent then remove all arrows Select visible cells (my fav one) Watch window Last but not least close all 😉
'Save As' is the first one on my list. It opens up the file explorer directly in the default folder (documents in my case). Save loads of steps when saving a file as it bypasses the awful default Office 365 'Save As' Screen.
Hi Leila. Thanks for sharing your tips. I modify my QAT regularly, depending on projects in play. I also add buttons for macros stored in my personal macro workbook. So, depends on what is happening at the moment. Looking forward to your videos in the new year! Thumbs up!!
Hi Leila, thanks for this. My QAT looks a lot like yours, with the Camera and Calculator. My first two buttons are "Open" and "Close All". To open the pre 2007 "Save As" screen I use F12. As I am full of static electricity, I am using a separate wireless keyboard and mouse, so my function keys work independently as they should, without having to use the fn key as well. I have also created my own ribbon called "My Buttons". As it contains nearly all the buttons I use most of the time, I keep it open while using my computer. It contains all the buttons on my QAT, except the "Speak On Enter" button. It has the following additional buttons - Switch Windows, All Borders, Zoom To Selection, Hide Columns, Unhide Columns, Form, Screen Clipping, Clear, Paste Values and a few more I find useful when creating Exercises for my training sessions. Most other times I use keyboard shortcuts whenever I can. I just love my shortcuts, must be because I got my first computer about seven years before the mouse for Windows was born and we had to learn the shortcuts.
Before watching this video, I only had the "Print preview", "Data validation", "Form" and ""Clear filter" buttons. But that was before watching this video :-) Great video, as usual! For your function keys, it is sometimes possible to set-up the behavior in the boot program ("Function keys enabled").
I have had Save As on my QAT for Excel and Word for years, so I can more quickly select the folder in which I want to save a file. By the way, not only do I add that command from More Commands > All Commands as she describes at 9:47, but I also get to it very quickly once I'm looking at the list by typing the first letter S that brings me to the S section of the list. That also works in File Explorer for finding files.
Dear honourable Mi-ss , I really appreciate you. Because I learned a lot from you. I say you're the best teacher. thank you so much. I would like to request you that if possible, please teach us some about power point. Because your tutorial is the best choice for us
Thanks Leila, this is interesting. As I have been learning keyboard shortcuts in earnest lately, I have not explored leveraging the QAT. I did particularly like the camera linked image option. Thanks for sharing
Some really interesting ways of using the QAT, Leila! I must say, I tend to have it stuck at the top with just the Save button present, but perhaps I should start using it as you do.
I use the icons for Paste Values, Paste Formatting, Paste Formulas and Clear Formatting and Clear Contents a lot. Also: select Visble Cells only. Also worth mentioning is the option to export your QAT settings and send them to someone else or your second computer to import the QAT there as well. This also saves a lot of time!!
Whilst it's not part of Excel, using the On-Screen Keyboard (add short-cut on your taskbar) can help with the F4 '$' issues. Ctrl + windows + o, click Fn and F4 appears.
Great list of commands. I’ll have to add spell check, the two paste ones, and $ reference to mine. I have undo/redo, some table commands including name, style, and filter button, and some alignment commands
Lots of great tips, thanks! I have the "back' and "forward" commands as the first icons on the QAT for Excel, Word and PowerPoint because when doing training or presentations and clicking on hyperlinks it's intuitive to use just like any browser.
Those are some interesting QAT selections. My QAT is all filled up with other useful things, mostly because I can't be bothered trying to remember keyboard shortcuts. Two buttons I have found to be invaluable are Clear All and Clear Formats. Other ones I use all the time are the four Insert / Delete Columns and Rows, the four Insert / Delete Table Columns and Table Rows. The Refresh and Refresh All ones are useful for PQ. I also like the button called 100%, which zooms things back to 100% without having to dick around with the slider thing.
You asked what is the first item I have on my QAT? It is Excel 2003, with no QAT. I like to get things done, be productive, and be accurate, so I only use 2007-2016 when forced to 😀 But when forced to, alt-1 is to do what the "comma icon" does.
Miss Leila Thank you very much for your videos, they helped me a lot lot in my work. As a database scrapper I would love to know how to export web based into excel Thank you
Hi Leila, I use customised Ribbons/Tabs setup for specific things like formatting, object creation, then use my QAT for a few generic functions that apply across the board, like print, save, save as, etc.
Great video..interesting and informative..I am a great fan of your excel videos..I am interested to learn more about advanced level excel formulas,charts,dashboards..please upload more on such videos..keep up the good work.
Hi Leila. I am also using QAT for pasting values which is the command i use often with alt key. And another commands i prefer and use are fill left and up. Fill down and fill right are already active with the shortcuts ctrl+D and ctrl+R ✌🏻 And i also use auto filter and refreshing options for power pivot and query too
Great video, didn't know about the camera feature, super useful. I have auto filter like many here, and also remove duplicates, select visible cells and insert pivot table.
Paste values is a great idea as it is used often. I have attach workbook to email, convert to PDF, Print Preview and personal macros. For spelling I use F7 as | have a separate keyboard attached to laptop, otherwise spelling would be useful to have in quick access toolbar.
For my QAT I have recorded a few simple macros which fills the marked cells with green, yellow or red fill, as well as a clear fill. I also have macros for changing text color to black or red. I have a signed the buttons colored icons. As an electrical engineer I use these aaaaall the time
Cool video-I am excited to try out the camera function. I like the "email as pdf" in my QAT. In fact that has become my go to method of saving an xlsx as a pdf.
I use it to run a macro that will center across a selection instead of merge and center. There used to be a QAT command for it at one point but it is gone now. I also use most of the same ones as you including camera. Another macro QAT unhides all my sheets at once.
Camera is the best one out of these (I wasn't aware it exists). In my case it's auditing icons (trace and remove precedent/ dependant cell links) as they're quite helpful if you are trying to understand a complex financial model.
Thanks for some great tips. Hoping that you will cover the Powerpoint and Word QATs as well soon. I still miss the feature in Excel 2003 and earlier that let you design your own buttons though. I find it useful to have single click new file, open, save, save as and file close on the left. Like you the various paste values and formula options, but also all the row and column insert and delete operations and cell borders options. Filter apply and clear is useful, and when adding features in the spreadsheet to access VBA, design mode and control properties are handy. The symbol button for inserting special characters (degree signs etc.) is also useful for technical work and adding foreign language accented letters without changing keyboards.
@Leila a tip for you: I haven't come across a keyboard which did not offer to change the functional keys to F keys - usually it is either an option in the keyboard software or in the computer bios (laptops usually) also the calculator tip - as excel is not the only software we are using and calculator can be really handy I just learned to type Win+R and then "calc" ENTER
Two that I use quite a bit are Clear All Filters and Refresh All. I have just changed my print preview to the full screen version. Thanks for that hint.
I have all the insert and delete functions for rows, columns, and cells and the subscript/superscript format buttons and name manager along with ordinary stuff on my QAT.
Great video! Organizing with a separator... Had no idea that was available. RE: the F4/function keys challenge... I know I couldn't "function" without my function keys being easily accessible. I discovered my Logitech keyboards have software that swaps the Function Keys default behavior so the primary use becomes secondary and F1-F12 becomes primary (i.e., no Fn + F4 business). Huge feature for me.
Currently I got a lot of the printing options there. I also have show gridlines, Insert Worksheet, autoformat, switch window and form. It can change depending on what I'm working on. Another thing I do is have a customised ribbon. Between that, QAT and a few keyboard shortcuts, I'm all set.
Hi Leila! This is my work account. On my personal account, I have watched you for YEARS!! My manager brought you up one day, or actually, she was describing your channel and I said, "OMG you watch Leila also!?!" I knew then I was in the right place, lol. This was an EXCELLENT video and I actually have taken your advice and added quite a few that you have, so thank you for that. I really need your help with something. I NEVER EVER use online excel, but my team does. No one else uses the desktop version which kills me. I cannot find the quick access toolbar for online Excel 365. Is it a myth or does it exist?? When you search in the online version, it doesn't even have the QAT in its engine! Please help me! How can I get it or can I at all?? Thank you for everything you do!!!
Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter
I have a button linked to a simple macro which steps through each page in the active workbook, returns the zoom level to 100% and the cursor/ active cell to the top left cell and finishes with the active sheet being the first sheet in the book and the cursor/active cell as A1. It really useful to leave a workbook tidy for someone else to pick up.
Any chance of providing a copy of that macro?
I was in need of that today! Any chance you could provide a link to the code? Much appreciated!
I want to know this Marco code too, much appreciated…
80% for life
you're one of the best excel video's out there!!
keep it up!!!
Thanks for the Paste Values tip. I think we need to all sign a petition to get Ctrl-Shift-V in Excel to work like the rest of the universe though.
My top favourite one I've installed on my colleague's PCs : Clear All Filter. It's changing your life when you're working daily on Tables.
Brilliant video. Its made my life so much easier in Excel to have those shortcuts in the QAT. Many thanks
1. Freeze panes
2. Filter Toggle
3. Format Painter
4. Sort Asc
5. Sort Desc
6. Auto Sum
7. Borders
8. Page Set Up
9. Print Preview (new)
Thank you for this video.
I like the idea for adding the Dollar Sign.
Adding Dollar Sign & Power Query shortcuts today.
I also added Draw Horizontal Text Box because I usually copy & paste a user's exact request from an email onto a sheet in the workbook. CYA.
Why couldn't I have found you months ago? The QAT would have saved me so much time in reformatting my companies documents (they were in bad shape). The organizational\project management tools I have created using tools and techniques I learned from you have helped us out tremendously. You have been so helpful. Thank you!!
You are an angel in disguise. I’m so glad you’re doing what you’re doing. Thank you!! You are awesome don’t ever believe anyone who tells you otherwise
I have been watching your videos for awhile now. I think that I am one of the more excel-experienced employees at my workplace. However the amount of stuff I am learning from your videos is insane. Honestly your videos are the only ones I check on youtube regularly. Keep up the fantastic work!
Sorry ... my QAT is a bit boring. It is limited to the 'basics', i.e. Save, Undo, File Open, Print Preview etc. But no surprise, you have once again provided me with several ideas. As usual, I will re-watch again ... and again ... to better understand the possibilities (and accompanied with another cup of coffee ... and a few Christmas cookies ... )
FYI ... my only internal rule is the QAT must always be located BELOW the Tool Bar.
PS
at the 12:25 mark "... Thank you for being here ... ".
HA! ... I think that is MY comment to YOU! Your videos are a standing calendar-date first thing every Thursday morning. Wishing you the best for 2022.
Yes! Thank you! QAT is the .no. 1 thing I recommend to other accountants on ways to improve speed & efficiency.
1: Format Painter, 2: save, 3: insert row, 4: delete row then many many more.
Few QAT items that i found useful are: 1. Trace Dependents; 2. Decrease decimals; 3. Auto Filter. Out of these, Auto Filter is my favourite, because it automatically applies filter on the item where the cursor is, with only a click of a button.
Hi Leila, this video is very useful. Now I have now customized my QA with most of your options. Thanks for sharing your knowledge. 👐🤝🙏💪
I’m a BIG fan of the QAT. I pronounce it “CAT” since there is no “u” after the “q”.
And if you put the QAT below the ribbon you not only get color icons, you also have a lot more real estate to put icons on it.
It’s a long walk from left to right, that is why in that configuration I call it the QAT walk. Easy to pronounce, easy to remember.
My QAT walk is completely filled from left to right, I regularly clean up if I want to add a new favourite button, because I need to see all my buttons on the QAT at one glance (otherwise you forget about it anyway). As you know the first 9 positions on the QAT are hotkey positions, so care needs to be taken in determining which buttons to put there. Here is my top 3: “Launch Power Query Editor” (ALT+1), “Launch Power Pivot Editor” (ALT+2), “Paste Values [only]” (ALT+3).
Users don’t like having to remember shortcuts, but pressing a button on the QAT is a-OK.
I love the cat walk! Thanks for sharing Geert.
Yep! Gotta love the name!
Hi Leila
My favorite is "clear all filters" as I get many pages wide sheet whare it is sometimes too much investigation to find al the set filters by browsing.
great idea.
Alt a c this is for pivot table filter
@@Seftehandle OK but then you change the ribbon to "Data" and this does not change back automatically. and I need to change from mouse to keyboard.
@@RogerStocker for the dilters the shortcut is ctrl shift L on windows. It always works.
Pivot Table is my first option in QAT!
Is there a way to adore a video instead of just liking it?
I've been using the QAT for 20 years now and I still learned a couple of new and really cool things here.
Thank you, Leila!
I've had the camera there forever too! That camera function has saved me, _numerous_ times. Great function, given the right situation.
love you leila ... you are rocking after wachitng your video my knowldge is flying... thank you very much
Happy to hear that!
Really your videos are more than Excellent
Many thanks for your great efforts for conveying these wonderful lessons, explanation and knowledge to all people who interested to get advanced skills.
Many thanks again.
Merry Christmas to you and to those who read this comment
"I can hold my cup and just click on this..." is such a relatable moment in all our excel and office daily life :')
Thank you again Leila! Great time-saving tips. I did not know about the separators that can be added to help organize.
Also did not know there was this cool Camera feature!
Once again, I ALWAYS learn so much from your wonderful videos!!! Thank you!!
Wishing you a Happy New Year !!!
I have used QAT for years. Most used commands have been Paste Values, legacy Print Preview, Delete Sheet Rows and PDF. Excellent video Leila!!
Great thanks leila.! Very useful productivity tool tips.
Great topic! I use copy/paste values only EVERY day as ALT 7 (this is my copy) and ALT 9 (paste values only). I also have add/remove filter, clear filter, queries and connections, launch Power Query, and launch Power Pivot window.
Things I'll be adding because of your video-full screen print preview, and the new measure. Thanks!!
If you have a lot of calculations and cross references within your data you might find trace decendants and trace precedents useful
Two favorite ones for me is 1) Document Location 2) AutoFilter
and Camera - wow! Select Visible Cells and custom macros are my favorites. Multiply items by negative 1; change debit to credit and credit to debit; concatenate 3 cells into one in 4 columns; date/time stamp; filter by 2 of our cash accounts. Thanks for the video.
OMG! Super helpful. The camera feature is the best thing since sliced bread. Thankfully I have a full-size keyboard to protect the coffee input system. I love your teaching style. Thank you for all the content you post. It is very generous of you to let us have access to so much valuable information.
One that I absolutely recommend,
Auto filter... It can automatically filter a range with value of your selected cell, with just 1 click! I use it a lot, specially when sharing screens with higher ups, always leaves them confused as to how I did that! 😂
Paste values & save as are the 2 best ones for me. I might consider adding the calculator too .
strikethrough, and set print area are my favourites
As an English teacher, I sometimes use excel to create materials and documents like appendixes and lists. Therefore the merge cells, wrap text, and text to columns are useful to me.
I just bought MS Office 2016 for the half price of Office '21 and got upgraded from my old 2007 version. Now I'm looking forward for a great practice with your videos!
I mostly use keyboard shortcuts, but have found that the QAT is a great way to pin four useful macros for fast access: 1 split text into columns by comma, 2 split text into columns by semicolon, 3 switch off system separators (which for me means use the English decimal point), and 4 switch to system separators (which for me is decimal comma). This means I can paste a csv from any external txt source and pivot the numbers in no time.
Coffee access…very important!😉
😁
Great video! I've used a personalized QAT for years. I also use a custom ribbon in conjunction with the QAT. If you position the ribbon in front of the Home ribbon, it becomes the default ribbon.
Excellent one it will improve productivity. Thank you. Wish you advance happy new year 2022.
Thank you Leila for covering this topic! My QAT has Paste Values, Clear All, AutoFilter, Clear Filter, Camera, Wrap Text, Pivot Table and Pivot Chart Wizard, Spelling, Expand Field, Select Objects, Manage Rules, Print Preview and Print and Accounting Number Format buttons. This QAT helps me in my regular work via the Alt shortcuts, really useful! I will also think of adding Macros now!😊👍
Thanks Vijay! Clear All is a good one too. I’ll add that to mine. Thanks for sharing.
Nice! Instantly added Camera and the legacy Print Preview to mine! I wish MS added a search field box in the Add commands box. It'd be much easier typing 'Paste' there and see every command containing that word.
Yep ,I can't believe there isn't an alphabetical search ability on the all commands list.
Leila, as always, it was a video with very useful information. Congratulations.
What I can add, in addition to this information, is that it is very useful to use our own customizations only for this workbook or for all workbooks option in the quick access bar we created. This prevents other users using Excel from seeing the confusing shortcut commands when they open the same workbook.
In addition, it is very tempting to add an import/export option to the quick access options that these shortcuts can be exported from excel, saved to the computer and saved as an add-on to other applications of the office program.
Thank you Leila, I'll add some of these as well.
Most used is "Paste Values", so I can use Alt+1 for that. I use it all the time, so the lines and formatting stays intact. Thanks for the idea!
One again I learned some new tricks. Thank you Leila 🙂
I use the (Dutch version of) switch to another workbook and of course the good old camera. Besides that I like to have the Alt-11 (show VBA) button there. I also like to use tha Save button and the Print Preview. I like your tip about the two different possibilities of print tpreview. And the last one I have is the Filter button. I fullt agree with the desire to have a full-functioning alternative to the F4 key! Thanks for yet another graceful tutorial. 🙂
Thanks for sharing, Ron!
Thanks a lot Leila for ur valuable videos, a lot of new and inspiring details as usual
Well I don't know what to mention and what to skip,
I will add all, I hope this would be useful for anyone
Set print area
Print preview full screen
Freeze pans
Edit links
Past values then formatting then formulas then link
Trace precedent then dependent then remove all arrows
Select visible cells (my fav one)
Watch window
Last but not least close all 😉
'Save As' is the first one on my list. It opens up the file explorer directly in the default folder (documents in my case). Save loads of steps when saving a file as it bypasses the awful default Office 365 'Save As' Screen.
F12
Hi Leila. Thanks for sharing your tips. I modify my QAT regularly, depending on projects in play. I also add buttons for macros stored in my personal macro workbook. So, depends on what is happening at the moment. Looking forward to your videos in the new year! Thumbs up!!
Hi, Leila! I've became a huge fan of Custom Views and Forms, definitely after your videos on that. So they're always on my QAT😃
Hi Leila, thanks for this. My QAT looks a lot like yours, with the Camera and Calculator. My first two buttons are "Open" and "Close All". To open the pre 2007 "Save As" screen I use F12. As I am full of static electricity, I am using a separate wireless keyboard and mouse, so my function keys work independently as they should, without having to use the fn key as well. I have also created my own ribbon called "My Buttons". As it contains nearly all the buttons I use most of the time, I keep it open while using my computer. It contains all the buttons on my QAT, except the "Speak On Enter" button. It has the following additional buttons - Switch Windows, All Borders, Zoom To Selection, Hide Columns, Unhide Columns, Form, Screen Clipping, Clear, Paste Values and a few more I find useful when creating Exercises for my training sessions. Most other times I use keyboard shortcuts whenever I can. I just love my shortcuts, must be because I got my first computer about seven years before the mouse for Windows was born and we had to learn the shortcuts.
Super super super helpful. I need to share this with my staff to improve the efficiency and productivity :)
Before watching this video, I only had the "Print preview", "Data validation", "Form" and ""Clear filter" buttons.
But that was before watching this video :-)
Great video, as usual!
For your function keys, it is sometimes possible to set-up the behavior in the boot program ("Function keys enabled").
I have had Save As on my QAT for Excel and Word for years, so I can more quickly select the folder in which I want to save a file. By the way, not only do I add that command from More Commands > All Commands as she describes at 9:47, but I also get to it very quickly once I'm looking at the list by typing the first letter S that brings me to the S section of the list. That also works in File Explorer for finding files.
I use the collapse and expand pivot table fields and then I’ve added a few macros as well.
Dear honourable Mi-ss , I really appreciate you. Because I learned a lot from you. I say you're the best teacher. thank you so much. I would like to request you that if possible, please teach us some about power point. Because your tutorial is the best choice for us
Agreed re the old version of Print Preview! One of the first things I’m sure to add!
My fave is paste link, paste value, paste formula 😀
very insightful!!
Great😃, in general I don't use QAT but after this video, I'll do it for sure, thank you Leila 🤗
NIce video. I have added the print preview full screen as, like you, I find the old school print preveiw so much more useful.
Great Video, I really liked it :). In my Toolbar is delete all filters and it‘S really life changing for me :)
👍
Helpfully, thanks Leila
Thanks Leila, this is interesting. As I have been learning keyboard shortcuts in earnest lately, I have not explored leveraging the QAT. I did particularly like the camera linked image option. Thanks for sharing
Some really interesting ways of using the QAT, Leila! I must say, I tend to have it stuck at the top with just the Save button present, but perhaps I should start using it as you do.
I use the icons for Paste Values, Paste Formatting, Paste Formulas and Clear Formatting and Clear Contents a lot. Also: select Visble Cells only. Also worth mentioning is the option to export your QAT settings and send them to someone else or your second computer to import the QAT there as well. This also saves a lot of time!!
Whilst it's not part of Excel, using the On-Screen Keyboard (add short-cut on your taskbar) can help with the F4 '$' issues. Ctrl + windows + o, click Fn and F4 appears.
Great list of commands.
I’ll have to add spell check, the two paste ones, and $ reference to mine. I have undo/redo, some table commands including name, style, and filter button, and some alignment commands
Lots of great tips, thanks! I have the "back' and "forward" commands as the first icons on the QAT for Excel, Word and PowerPoint because when doing training or presentations and clicking on hyperlinks it's intuitive to use just like any browser.
Thank you and wish you happy new year dear from all of us!! Lots of love and respect
Thank you! Happy new year to you too!
Those are some interesting QAT selections. My QAT is all filled up with other useful things, mostly because I can't be bothered trying to remember keyboard shortcuts. Two buttons I have found to be invaluable are Clear All and Clear Formats. Other ones I use all the time are the four Insert / Delete Columns and Rows, the four Insert / Delete Table Columns and Table Rows. The Refresh and Refresh All ones are useful for PQ. I also like the button called 100%, which zooms things back to 100% without having to dick around with the slider thing.
Must have items on QAT for me a 'Select current region' & 'Select visible cells only' , Sort Asc, Sort Desc & Camera are valuable to my workflow too
You asked what is the first item I have on my QAT? It is Excel 2003, with no QAT. I like to get things done, be productive, and be accurate, so I only use 2007-2016 when forced to 😀
But when forced to, alt-1 is to do what the "comma icon" does.
Miss Leila
Thank you very much for your videos, they helped me a lot lot in my work.
As a database scrapper I would love to know how to export web based into excel
Thank you
Hi Leila,
I use customised Ribbons/Tabs setup for specific things like formatting, object creation, then use my QAT for a few generic functions that apply across the board, like print, save, save as, etc.
Happy new year
Great video..interesting and informative..I am a great fan of your excel videos..I am interested to learn more about advanced level excel formulas,charts,dashboards..please upload more on such videos..keep up the good work.
Happy New Year
Hi Leila. I am also using QAT for pasting values which is the command i use often with alt key. And another commands i prefer and use are fill left and up. Fill down and fill right are already active with the shortcuts ctrl+D and ctrl+R ✌🏻 And i also use auto filter and refreshing options for power pivot and query too
The traditional Save As (which skips the folder selection intermediary screen), auto filter related buttons and remove duplicates
F12
Remove duplicates is on mine as well!
Great video, didn't know about the camera feature, super useful. I have auto filter like many here, and also remove duplicates, select visible cells and insert pivot table.
Paste values is a great idea as it is used often. I have attach workbook to email, convert to PDF, Print Preview and personal macros. For spelling I use F7 as | have a separate keyboard attached to laptop, otherwise spelling would be useful to have in quick access toolbar.
Great video! Two on my QAT that I use often are the Visual Basic Editor and Select Current Region.
For my QAT I have recorded a few simple macros which fills the marked cells with green, yellow or red fill, as well as a clear fill. I also have macros for changing text color to black or red. I have a signed the buttons colored icons.
As an electrical engineer I use these aaaaall the time
Thanks for the tip!
Omg I so get the dollar sign on the quick access bar 😂
😁
Cool video-I am excited to try out the camera function. I like the "email as pdf" in my QAT. In fact that has become my go to method of saving an xlsx as a pdf.
👍
I use it to run a macro that will center across a selection instead of merge and center. There used to be a QAT command for it at one point but it is gone now. I also use most of the same ones as you including camera. Another macro QAT unhides all my sheets at once.
Excellent ideas. I must try them!
I'd not heard of it until u showed it
To hide the toolbar you can also double-click on the headers ('Home' etc)
'Select visible cells' is the one I can't do without on the QAT!
Alt + ;
Camera is the best one out of these (I wasn't aware it exists). In my case it's auditing icons (trace and remove precedent/ dependant cell links) as they're quite helpful if you are trying to understand a complex financial model.
I have paste special value and filter the current cell...the 2nd one help a lot...
Thanks for some great tips. Hoping that you will cover the Powerpoint and Word QATs as well soon. I still miss the feature in Excel 2003 and earlier that let you design your own buttons though. I find it useful to have single click new file, open, save, save as and file close on the left. Like you the various paste values and formula options, but also all the row and column insert and delete operations and cell borders options. Filter apply and clear is useful, and when adding features in the spreadsheet to access VBA, design mode and control properties are handy. The symbol button for inserting special characters (degree signs etc.) is also useful for technical work and adding foreign language accented letters without changing keyboards.
@Leila a tip for you: I haven't come across a keyboard which did not offer to change the functional keys to F keys - usually it is either an option in the keyboard software or in the computer bios (laptops usually)
also the calculator tip - as excel is not the only software we are using and calculator can be really handy I just learned to type Win+R and then "calc" ENTER
Thank you Leila.
Two that I use quite a bit are Clear All Filters and Refresh All. I have just changed my print preview to the full screen version. Thanks for that hint.
I have all the insert and delete functions for rows, columns, and cells and the subscript/superscript format buttons and name manager along with ordinary stuff on my QAT.
Great video! Organizing with a separator... Had no idea that was available. RE: the F4/function keys challenge... I know I couldn't "function" without my function keys being easily accessible. I discovered my Logitech keyboards have software that swaps the Function Keys default behavior so the primary use becomes secondary and F1-F12 becomes primary (i.e., no Fn + F4 business). Huge feature for me.
Thanks for the tip, Joe.
Currently I got a lot of the printing options there. I also have show gridlines, Insert Worksheet, autoformat, switch window and form. It can change depending on what I'm working on. Another thing I do is have a customised ribbon. Between that, QAT and a few keyboard shortcuts, I'm all set.
Wrap text, paste values, Format Painter, group/ungroup, delete rows/columns, name manager and others.
Hi Leila! This is my work account. On my personal account, I have watched you for YEARS!! My manager brought you up one day, or actually, she was describing your channel and I said, "OMG you watch Leila also!?!" I knew then I was in the right place, lol. This was an EXCELLENT video and I actually have taken your advice and added quite a few that you have, so thank you for that. I really need your help with something. I NEVER EVER use online excel, but my team does. No one else uses the desktop version which kills me. I cannot find the quick access toolbar for online Excel 365. Is it a myth or does it exist?? When you search in the online version, it doesn't even have the QAT in its engine! Please help me! How can I get it or can I at all?? Thank you for everything you do!!!
My favorite QAT is erase filter, because I can have a visual cue of my data with any filter on. I can erase easily if I need to.