{"id":109,"date":"2011-03-29T07:35:13","date_gmt":"2011-03-29T13:35:13","guid":{"rendered":"http:\/\/www.properwichita.com\/consulting\/?p=109"},"modified":"2011-04-27T23:06:16","modified_gmt":"2011-04-28T04:06:16","slug":"tip-freeze-a-column-in-excel-2010","status":"publish","type":"post","link":"http:\/\/www.properwichita.com\/consulting\/2011\/03\/29\/tip-freeze-a-column-in-excel-2010\/","title":{"rendered":"Tip: Freeze a Column in Excel 2010"},"content":{"rendered":"

Have you ever had a large spreadsheet and had trouble\u00a0remembering what the row or column names were when you had to scroll them off the screen?<\/p>\n

A quick fix in Excel 2010 can help lock that first row or column in place, allowing you to scroll to the entry point of your data without scrolling that important information off the screen.<\/p>\n

As an IT support and networking consultant, I’ve been asked to provide a solution to this problem several times.\u00a0 Here’s the quick fix:<\/p>\n

Step 1: <\/strong>Highlight the column of data you wish to lock in place.<\/p>\n

\"Highlighting

Highlighting the Column<\/p><\/div>\n

Step 2: <\/strong>Click the View<\/strong> tab on the top menu bar<\/p>\n

\"Choosing

Choosing the View Menu<\/p><\/div>\n

Step 3: <\/strong>Select Freeze Panes<\/strong> from the ribbon bar<\/p>\n

\"Freeze

Freeze Columns Option on the Ribbon Bar<\/p><\/div>\n

Step 4: <\/strong>Click Freeze First Column<\/strong><\/p>\n

That’s it!\u00a0 Now, when you scroll through the data to the right, the data will slide, leaving that first column in view:<\/p>\n

\"The

The Locked Column<\/p><\/div>\n

If you have questions about this or any of our other tips, give Proper Technology Solutions a call at (316) 337-5628 or reach us at our after hours IT support line (316) 210-7112.\u00a0 We can help with all your IT networking needs in Wichita and surrounding areas.\u00a0 With our low rates starting at $70\/hour with no minimum service charges we can help lower your IT support costs.<\/p>\n

Our highly certified computer techs and network engineers can solve all your information technology issues on-site or through remote access, while providing service small businesses can afford.<\/p>\n","protected":false},"excerpt":{"rendered":"

Have you ever had a large spreadsheet and had trouble\u00a0remembering what the row or column names were when you had to scroll them off the screen? A quick fix in Excel 2010 can help lock that first row or column … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4,5,134],"tags":[6,25,10,9],"_links":{"self":[{"href":"http:\/\/www.properwichita.com\/consulting\/wp-json\/wp\/v2\/posts\/109"}],"collection":[{"href":"http:\/\/www.properwichita.com\/consulting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.properwichita.com\/consulting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.properwichita.com\/consulting\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.properwichita.com\/consulting\/wp-json\/wp\/v2\/comments?post=109"}],"version-history":[{"count":5,"href":"http:\/\/www.properwichita.com\/consulting\/wp-json\/wp\/v2\/posts\/109\/revisions"}],"predecessor-version":[{"id":205,"href":"http:\/\/www.properwichita.com\/consulting\/wp-json\/wp\/v2\/posts\/109\/revisions\/205"}],"wp:attachment":[{"href":"http:\/\/www.properwichita.com\/consulting\/wp-json\/wp\/v2\/media?parent=109"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.properwichita.com\/consulting\/wp-json\/wp\/v2\/categories?post=109"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.properwichita.com\/consulting\/wp-json\/wp\/v2\/tags?post=109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}