{"id":9223,"date":"2019-10-16T06:54:45","date_gmt":"2019-10-16T04:54:45","guid":{"rendered":"http:\/\/www.officetodo.com\/public\/?p=9223"},"modified":"2019-10-16T06:54:46","modified_gmt":"2019-10-16T04:54:46","slug":"tips-to-working-with-big-excel-tables-excel-2010","status":"publish","type":"post","link":"https:\/\/www.officetodo.com\/public\/tips-to-working-with-big-excel-tables-excel-2010\/","title":{"rendered":"Tips to working with big excel tables | Excel 2010"},"content":{"rendered":"\n<p>When working\nwith Excel spreadsheets there are four steps I always go through before\nstarting with anything. <\/p>\n\n\n\n<p>First off\nwhat I do is apply filters. With big tables there is always some filtering\nneeded &#8212; Under Home tab and Editing section choose Sort &amp; Filters and then\nclick on Filters.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p>The second\nstep is freezing the panes. This gives possibility to see the column headers\nwhile you are scrolling down. Freeze Panes are under View Tab and Window\nSection.<\/p>\n\n\n\n<p>Thirdly I do\na bit of formatting. I select all the data by holding ctrl and pressing A and\ngive to the data the same font and size. This makes the table visually better\nto work with.<\/p>\n\n\n\n<p>Fourth and\nlast step is hiding unneeded columns. You can also delete the columns, but to\nbe safe its better to hide them as you might need them later. Choose the\ncolumns, right mouse click and choose Hide.<\/p>\n\n\n\n<p>Now you can\nstart working with the excel table<\/p>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Tips to working with big excel tables | Excel 2010\" width=\"625\" height=\"352\" src=\"https:\/\/www.youtube.com\/embed\/6CYkoPkL_24?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>When working with Excel spreadsheets there are four steps I always go through before starting with anything. First off what I do is apply filters. With big tables there is always some filtering needed &#8212; Under Home tab and Editing section choose Sort &amp; Filters and then click on Filters.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3515],"tags":[3533,3532,3729,3728],"class_list":["post-9223","post","type-post","status-publish","format-standard","hentry","category-excel-2010","tag-big","tag-excel-2010","tag-tables","tag-tips"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/9223","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/comments?post=9223"}],"version-history":[{"count":1,"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/9223\/revisions"}],"predecessor-version":[{"id":9224,"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/9223\/revisions\/9224"}],"wp:attachment":[{"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/media?parent=9223"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/categories?post=9223"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/tags?post=9223"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}