Theory
Meera wants a price list on the wall
Meera's sheet computes perfectly, but she also wants a printed price list to pin near the counter: her shop's logo at the top, a neat title, the rupee sign beside each price, and the date at the bottom so customers know it is current.
None of that is a formula. It lives in a different layer of Excel, the things that sit on top of the grid or appear only when you print. That layer is this lesson.
Theory
Stickers on a graph-paper page
Imagine your worksheet is a sheet of graph paper. The numbers are written inside the little squares (cells). But a logo, an arrow, a text box: those are stickers you press on TOP of the paper. They float over the squares, movable anywhere, belonging to no single cell. Understanding this "floating layer" is the whole idea: objects sit above the grid, not inside it.
Theory
The floating objects
From the Insert tab:
- Picture: a logo or product photo. It floats as an object; drag it anywhere, resize by its corner handles.
- Shapes: arrows, rectangles, callouts, to point at or highlight data.
- Text Box: free text not tied to any cell ("Festival Offer!").
- Symbols (Insert > Symbol): characters the keyboard lacks, the rupee sign, copyright, degree, currency symbols. Insert one where the cursor sits.
All of these except symbols are objects on top; a symbol goes into the cell text, like any letter.
Theory
Headers and footers: print-only text
A header repeats at the top of every printed page; a footer at the bottom. Meera puts her shop name in the header and the date plus page number in the footer.
Reach them via Insert > Header & Footer (or the Page Layout view). You can type fixed text or drop in fields that fill themselves: &[Page] for page number, &[Date] for today's date, &[File] for the filename.
Key point: headers and footers do not show in the normal grid view, only on the printout and in Page Layout / Print Preview.
Quiz
Meera inserts her shop logo, but it will not stay inside cell A1, it floats and covers several cells. Is something wrong?
- No, pictures are floating objects that sit ON TOP of cells, not inside one
- Yes, she must paste it into the cell as text
- Yes, the logo file is corrupted
- No, but it will disappear when she saves
Show the answer
No, pictures are floating objects that sit ON TOP of cells, not inside one
Nothing is wrong. Pictures, shapes and text boxes are objects that float above the grid; they are not cell contents and never live "inside" a single cell. You position them by dragging. Expecting a logo to sit in A1 like a number is the classic beginner misunderstanding of Excel's object layer.
Think first
Why can't she see the footer?
Meera adds a footer with the date, but back in the normal grid it is nowhere to be seen. She thinks it failed. Take five seconds: where does a footer actually appear, and how can she check it?
Show the answer
Headers and footers appear only on the printed page, not in the normal grid view. Meera should open Print Preview (or switch to Page Layout view), and there her dated footer is, sitting at the bottom of every page. Nothing failed; footers simply live in the print layer, invisible during normal editing.
Watch out
Where marks leak
Saying a picture is "in cell A1", objects float above cells, they are not cell contents. Expecting headers/footers in the normal view, they show only on printouts / Page Layout / Print Preview. And confusing a Text Box (floating object) with typing into a cell (grid content). One-mark questions often ask "which Insert-tab items float above the sheet?", answer: pictures, shapes, text boxes.
Theory
From data to document
This lesson is where a spreadsheet stops being just calculation and becomes a document you can hand to a human: a price list, an invoice, a report cover. That instinct, make the data presentable for its reader, returns in every subject, from your BCA project report to a database's formatted query output. Next: saving it all safely, including the CSV format that quietly drops every bit of this styling.
Summary
Key takeaways
- Pictures, shapes and text boxes are objects that FLOAT above the grid, not cell contents.
- Insert them from the Insert tab; drag to position, corner-handles to resize.
- Symbols (Insert > Symbol) add keyboard-less characters like the rupee sign, INTO the cell.
- Headers repeat at the top and footers at the bottom of every PRINTED page.
- Use fields like &[Page] and &[Date]; headers/footers show only in print/Page Layout view.
- Memory hook: numbers live in the squares; logos and shapes are stickers on top.