excel basics

When you work with a large table, it’s easy to lose headings when you scroll.Freeze Panes lets you keep important rows or columns always visible while scrolling. Freeze the Top Row (Most Common) Use this when your column titles are in Row 1. Unfreeze Rows or Columns Use this to remove all freezes. Freeze the

Splitting a worksheet lets you view different parts of the same sheet at the same time.This is very useful when working with large tables or many rows and columns. 👉 You can split the screen: Split the Worksheet Horizontally (Top and Bottom) This keeps the top rows visible while you scroll down. How to use

Zooming in Excel helps you see your worksheet better.You can make the screen bigger or smaller without changing the actual data. Method 1: Quickly Zoom Using the Status Bar This is the fastest way to zoom. Method 2: Zoom to an Exact Percentage Use this when you want a specific zoom level, like 100% or

Sometimes you need to share an Excel file with people who use older versions of Excel (before Excel 2007).In this case, you should save your file as Excel 97–2003 (.xls) instead of .xlsx. Method 1: Save One File as Excel 97–2003 Step-by-step: ✅ Your file is now saved in the older format and can be

There are two simple ways to merge Excel files: Method 1: Merge a Few Excel Files (2–10 Files) This method uses Excel’s built-in Move or Copy feature.No coding required 👍 Step 1: Open All Excel Files 👉 Keep all files open at the same time. Step 2: Select Sheets to Move ✔ To select many

Excel automatically saves temporary copies of your work in the background.This means you can often recover your file even if: Let’s go step by step. Case 1: Excel Crashed and Reopens What happens? When Excel crashes, the next time you open Excel, you will see the Document Recovery Pane. What to do: Case 2: Recover

Excel allows you to open and view two or more workbooks at once.This is very useful when you want to compare data, copy information, or check differences between files. Step 1: Open More Than One Workbook 👉 Make sure both files are open at the same time before continuing. Step 2: Arrange All Open Workbooks

Excel allows you to change the overall look of your workbook with just one click.This is called a Theme. A theme includes: When you change a theme, your entire workbook updates automatically. Step 1: Check the Current Theme Step 2: See the Theme Colors and Fonts 👉 In the Office theme, the fonts are: Step

Checkboxes in Excel are very useful. You can use them to: You can also insert a simple check mark symbol, but a checkbox is more powerful. 1. How to Insert a Checkbox 2. Link a Checkbox to a Cell A checkbox works best when it is linked to a cell. 3. Use the Checkbox with

The status bar is the bar at the bottom of the Excel window. It can help you do quick calculations and check useful information without using formulas. 1. Quick Calculations with the Status Bar You will see: Excel does these calculations automatically for you. 2. Change Workbook View Easily On the right side of the