How to Fix an Excel Table that’s Slow to Scroll or Respond

Sign up for our Excel webinar, times added weekly: www.excelcampus.com/blueprint...
In this video, I demonstrate how to resolve a performance issue caused by whole column references in Excel Tables. If your sheets that contain tables are slow to scroll and lag a bit, then this might be causing the issue. In the video, I share additional Excel tips and techniques to help save time with data-related tasks.
If you’d like to read the accompanying blog post on my website, you can access it here: www.excelcampus.com/tables/ta....
Related Videos:
Excel Tables Tutorials Playlist: • Excel Tables Tutorials
Excel Tables Tutorial: Beginners Guide for Windows & Mac: • Excel Tables Tutorial:...
Tips & Shortcuts for Inserting Excel Tables: • The Best Shortcuts For...
Grab our Free Excel Pro Tips eBook that is packed with time-saving tips to help you become an Excel Hero at: excelcampus.com/free
#MsExcel #ExcelCampus
00:00 Introduction
01:02 Performance Issue
03:25 Slow Scrolling
04:47 Resize Table
06:01 Create Single Cell Table

[@Angels2ndClass]

OMGosh! YOU ARE THE BEST!! You are the only person who addresses this issue that I could find over the last hour.

[@ExcelCampus]

Glad I could help. 😀

[@ThaClancyFam2]

THANK YOU!!!! I got the answer in the first 40 seconds of the video.

[@mrmusicloverable]

Good tip John. A lot of people are not even aware of those types of mistakes. I had to help a colleague who made a similar mistake however in her case she mistakenly referenced the whole rows ( basically the whole sheet was selected instead of just her data)while creating her table and that prevented her from creating her pivot table. I love excel table.

[@ExcelCampus]

Thanks, MrTechnology! Great point about whole-row references. I hadn't thought about that case.

[@RameshBabu-oy7ln]

Thanks a lot Jon ji. You rescued me out of tension.

[@database_tips_tricks]

different class, best excel channel on you tube

[@thomasweber3954]

Thank you so much! You saved my day, because before i didn't find out why excel got so slow on Zooming and scrolling

[@wayneedmondson1065]

Hi Jon. Thanks for the tips on this issue. I have not fallen into the trap (defining the table to include the entire column), but I have seen worksheets from others set up this way. Good to know why it occurs and how to correct for it. Thanks for sharing :)) Thumbs up!!

[@mohammadrezasohrabi4979]

I have found this channel really helpful.
The contents are rich enough besides mentioning the pros and cons of some of the functions, making it really interesting and constructive
Thanks, Jon.

[@ExcelCampus]

Thanks for the feedback @mohammadrezasohrabi4979 😀

[@cherianiype]

Good tip.... This could easily be missed by even seasoned users. Thx for sharing

[@shyamsundar-ul5bn]

amazing all my colleagues faced this issue you are sheer genius..work productivity increased by 100%🖖

[@ExcelCampus]

It's good to know that your productivity increased by 100%! 😊

[@keitho64]

Nicely done, I had this exact issue with performance and now it is resolved. Thank you!

[@ExcelCampus]

Great to hear that! 😀

[@dayakumar2314]

This is very helpful. Thank you for your work.

[@ExcelCampus]

Glad it was helpful! 😀

[@barttitulaerexcelbart9400]

Thanks John, I also use ctrl-* to check if there are no cells nearby...

[@tchambard]

Thanks much for the "heads up". Since I'm relatively new to Tables, this is really good to know!

[@ExcelCampus]

Thanks Trina! I'm happy to hear it. We just created a playlist with our Excel Table tutorials. The videos will contain a lot of useful tips and techniques if you are new to Tables. Here is a link. th-cam.com/play/PLKbOx3gUV_E8EyPF_KckH1Mdld-oAZoDf.html
I hope that helps. Thanks again and have a nice day! 🙂

[@muramasamaki8294]

Very useful video, I went through a lot of information uninstalling countless Windows updates and finally solved the problem, thank you very much for the video!

[@ExcelCampus]

Glad it helped! 😀

[@Softwaretrain]

Thanks John, you always shows great tips.

[@Videolover777]

Thanks Jon - useful information as always.

[@randyhaimila6476]

I was just learning about tables last weekend, so this is relavent to my work and useful as always. Thanks for sharing.

[@ExcelCampus]

Thanks Randy! I'm happy to hear you are learning about and using Tables. They are a fantastic feature of Excel.

[@darrylmorgan]

Really Great Tips,I Think Most Of Us Have Made The Same Mistake By Unknowingly Using Whole Column References...Thank You Jon :)

[@ExcelCampus]

Thanks Darryl! Happy to hear I'm not alone. 😉

[@ultimanga]

Thank you!

[@nadermounir8228]

Thank you Jon. Great tutorial 👌

[@lilydi2614]

Thank John! those are really useful tips.

[@eeeraerts]

Thank you Jon as usual very good tip!!

[@angelaisland4036]

Thank you I have done this and it took me awhile to figure it out. I love the scroll bar as a warning.

[@captainnaveed3781]

Very useful video, keep it up!

[@ExcelCampus]

Thanks a lot! 😀

[@eduarddenk7953]

THANKS, this helpt me a lot!!!

[@ExcelCampus]

You're welcome, Eduard! 😀

[@rory1653]

Great tip 👍

[@AdamPNelson]

very helpful!

[@simoiyahector-morales3781]

Excellent tip, thank you for sharing sir

[@ExcelCampus]

Thanks Simoiya! 🙂

[@yyusof78]

marvelous, You are the best

[@ExcelCampus]

Thank you, Yyusof! 😀

[@mojotramp]

Great; thanks

[@atecorztv8100]

Thanks! 👌

[@kiranachanti1668]

Thanks! This was helpful and fixed my issue

[@ExcelCampus]

Great to hear, thanks for watching!

[@bobabout256]

Thanks for the tip. I use Ctrl + t to create a table which is quicker than wandering about menus 👍

[@fredrickmerie451]

Great tip, thanks alot!!

[@ExcelCampus]

Thanks Fredrick! 🙂

[@lilminishlomit]

Thank you Jon! I always appreciate your videos. Very clear, concise but generous with information/ tips at the same time. I looked at your Videos file for any tips on how to save a workbook/ excel file or even Word document in a shared drive, where multiple users can use and save at the same time (collaborate). I am not looking for the one which the file is saved in a Cloud, but in a shared drive. I did not find it in your teaching Videos collection. Would you consider making a video of it? @ExcelCampus-Jon

[@teresaherrera848]

Hello I was watching your video and was wondering if I can keep adding information to the same spreadsheet

[@edilpoulina1870]

Dear Jon.
Thanks for these GR8 tip. I have one question. When creating a Table, either through "Format as Table" or "Insert Table", the Create Table Dialogue Box presents an absolute reference for the Table, but it still expands automatically when adding rows to it. I know Tables in Excel are designed to expand automatically, so what is the added value of the absolute reference here? (A range name (for the same range as the Table range) would not expand automatically.)

[@mobilaizer]

This does not work with the latest version of Excel :(

[@stevewalters1665]

Thanks for the video Jon. I'm actually trying to find a solution for a problem I have with some of my tables. I have tables that take a very long time to expand when I paste in the data (formulas are not intensive and data sets are not overly large). However if I past the same data in the first row after the table it expands and calcs immediately, no delay at all but then the top row is without data (this is what I have been doing, then deleting out the top row). Do you have any insight why excel might be struggling to expand the table and requiring a work around to get better performance.

[@dimitarbushkalov2380]

Hello Jon, I have a dashboard which has Y and X axis values linked to a dynamic named range. I use a scrollbar to scroll in the dashboard from left to right, and when I click the scrollbar to scroll the columns in the chart take time to load. Any ideas how i can fix that?

[@5gunnsnz]

A quick way to check all existing tables is to use the Name Manager and check the "Refers to" column🙂

[@jeffdavis7150]

This is a great and thoughtful tip, John; I have experienced the small scroll bar in the past and had no idea what caused it. I thought it was a ghost in the machine. 😉
By extension, I’m guessing that lazily copying and pasting whole columns, rows, or sheets multiple times within a VBA macro instead of manipulating manageable ranges for copy & paste could cause a performance slowdown as well?

[@jimmy_changa6964]

I haven’t ever made that mistake because the way he created the table, is something I don’t do lol I always use ctl+T and that usually detects the range for the most part. But good to know I guess. 👍🏽

[@ExcelCampus]

Thanks Jaime! For others reading, Ctrl+T is the shortcut to insert a table. If you have the columns selected before pressing Ctrl+T, Excel will still put the whole column references in the Create Table window. Unfortunately, it doesn't detect the used range if you have entire columns selected. At least not yet. Hopefully, this feature will be added in the future. 🤞
Thanks again and have a nice day! 🙂

[@brook3518]

I have an issue when using fill color (while I am selecting the color), the excel just lagging and froze for 10-20seconds. the excel will run normally after that, but once I just click on "fill color", the excel will freeze. please help.
It happens to only this excel file.

[@darrinwesterfeld8948]

How do you use this tip on a table with a dynamic row count?

[@valensrwema4251]

Really great tips, thanks again 👍,
I have a question , after creating a table in excel how can i get back to the original dataset?
Thanks

[@philipmikheikin]

right click in table, convert to range.
dedign tools, table, convert to range

[@ExcelCampus]

Hi Valens,
As Philip mentioned, you can use the Convert to Range button to remove the Table and keep the data. That button also keeps the Table style/formatting. If you want to remove the formatting as well, you will want to first change the style to None before pressing Convert to Range.
I hope that helps. Thanks again and have a nice day! 🙂

[@nd4763]

Really useful. Do you offer some free/paid vba courses ?

[@jawedabro4558]

Dear, Excil 2013 Editing the record too slow in my 32bit 2gb laptop window7 ... what can i do...?

[@anil11996]

Sir, how to skip already protect excel workbook and next file protect with password by excel vba

[@jonelles7223]

What are the benifits of formatting data into a table?