Excel Inserting Cells and Splitting Screen

Dividing the screen into independent parts to view different sections simultaneously.

Holding a row or column in place while scrolling through the rest of the worksheet.

The cell where the horizontal and vertical freeze lines appear on a worksheet.

Keyboard shortcut to effectively freeze the worksheet.

Viewing multiple regions of a worksheet simultaneously.

Click a cell below the desired row location, then choose "Rows" from the Insert menu.

Select desired number of rows below insertion point and choose "Rows" from the Insert menu.

Select range of affected cells, click "Cells" in Insert menu, choose shift direction (right/down), and confirm.

Option to move existing data to the right when inserting a new column.

Option to move existing data downwards when inserting a new row.

Keeping important top or side information visible while scrolling through a spreadsheet.

Keeping a particular top row visible while scrolling down in a spreadsheet.

Keeping a particular left-most column visible while scrolling across a spreadsheet.

Making header data visible across all parts of the spreadsheet, while scrolling.

The structure displayed to the user in a spreadsheet software. It also contains the essential data arranged in a table format.

A visual representation of data using various graphical elements like bars, lines, or pie slices.

The horizontal axis in a chart, usually representing categories or groups of data.

The vertical axis in a chart, usually representing numerical values or quantities.

A chart that is placed directly inside a worksheet, within the same sheet as the data it represents.

A separate sheet in an Excel workbook that is dedicated solely to displaying a chart, without any other data.

A single unit within a spreadsheet where you can enter data (numbers, text, formulas). It's formed by the intersection of a row and column. Example: cell F3 is at the intersection of row 3 and column F.

The unique address of a cell in a spreadsheet. It combines the column letter and row number. Example: F3 refers to the cell in column F and row 3.

A rectangular group of cells in a spreadsheet. It's defined by the first and last cell in the range. Example: F7:G14 means all cells from F7 down to G14.

A worksheet is a single sheet within a spreadsheet program. It's like a page with rows and columns. A workbook is a file that contains multiple worksheets.

Spreadsheets are used to organize, calculate, and analyze data. You can perform calculations, track budgets, create charts, and much more.