Scroll down and across your spreadsheet, and youРІР‚в„ўll see that the information you need is always right there within view! Click on the row underneath your column headers.You can do this by using ExcelРІР‚в„ўs handy РІР‚Сљfreeze panesРІР‚Сњ feature. ThereРІР‚в„ўs nothing worse than scrolling through a huge spreadsheet that requires you to continuously go back up to the top to see what your column headers are.Р”Р‡ortunately, you can make your column headers and your row numbers stay right where they are РІР‚вЂњ meaning you can always see them, no matter how far down the spreadsheet you go. We actually touched on this in an article.

ItРІР‚в„ўs important to note that the style you choose will be applied to every selected cell, so pay attention to the cells youРІР‚в„ўre selecting because it may affect how the style appears. If Excel doesnРІР‚в„ўt have the option you want already, you can build your own style. >HereРІР‚в„ўs how I would use the conditional formatting feature to highlight the oldest distilleries. Click on the downward arrow button, and click РІР‚СљMore Commands.РІР‚Сњ Find the РІР‚СљConditional FormattingРІР‚Сњ option in the scrolly list, and click the arrow to add it to your Ribbon or Quick Access Toolbar. Note: If you donРІР‚в„ўt see the conditional formatting command in your Ribbon, then visit the top, left-hand corner of your screen. To get things done in Excel, youРІР‚в„ўll need to understand the Ribbon. An example of a cell label (or reference) then is: A2, H5, etc. YouРІР‚в„ўll notice the rows are numbered while the columns are labeled with letters. Worksheets are comprised of a near infinite number of rows and columns, which together create cells.Р”В¬ells are where you store your information, such as text, numbers, pictures, dates, times and formulas. Aside from crunching numbers, what else can I do with Excel?Р”В«efore you jump into learning cool things like Macros and Power Pivot, itРІР‚в„ўs important to get your bearings first.Р”Р„ Microsoft Office Excel workbook is an xlsx (if youРІР‚в„ўre using Excel 2007+) file that contains one or more worksheets that you can use to organize different types of related information, according to Microsoft.Excel also comes in handy for personal use to manage your finances, organize your job search, or even plan out a novel! If youРІР‚в„ўre entirely new to Microsoft Excel, here are some resources you may find useful: Excel is used in virtually every industry, including finance, retail, healthcare, communications, information technology and many more. Just about everyone, in so many different ways.

Learn excel online tutorial