How to Freeze Panes in Excel

excel freeze panes

Excel Freeze Panes Unfreeze Panes | Freeze First Column | Freeze Rows | Freeze Columns | Freeze Cells | Add Button When you work with a large table of data in Excel, the freeze panes allows you to freeze rows or columns for better visibility. In other words, you can keep one part of the … Read more

How to Split Worksheet in Excel

split worksheet

Split Excel Worksheet You split worksheet in Excel to view different parts by using the split menu. You are going to need this when the worksheet is long. Below are the steps. 1. Select a cell that you like to split. For instance, we select cell A5. 2. Click “Split” on the View tab. 3. … Read more

How to Zoom in or out in Excel

excel zoom

Excel Zoom You can Zoom in and out in Excel by using zoom in the status bar and using the View tab. 1. To zoom in/out of your worksheet, click the plus or minus sign on the status bar. The bar shows the percentage number so that you can magnify the worksheet to your likings. … Read more