Srini Vanamala – Page 7 – Learn Excel Easy

Author: Srini Vanamala

Shortcuts

Excel Delete Row Shortcut: Ctrl+Minus, and delete many rows fast

Delete a row in Excel with Shift+Space then Ctrl+Minus, delete several at once, delete every filtered row, and undo.

September 29, 2026

Print, Share & Protect

How to Add a Header in Excel (printed header, not the heading row)

Add a header in Excel that prints at the top of every page: title, date, file name, page numbers, a logo — and the difference from a heading row.

September 29, 2026

Charts

How to Create a Chart in Excel: the 5-step method for any chart

How to create a chart in Excel: arrange the data, select it, pick the chart type that fits, then title, label and tidy — the same five steps for every chart.

September 29, 2026

Charts

Excel Bar Chart: make one, sort the bars, and label them

Make an Excel bar chart in four steps, put the biggest bar on top, add data labels, change the colour of one bar, and choose bar vs column.

September 29, 2026

Dates & Times

Excel Date Format: change how dates look, and fix dates that won’t change

Change the date format in Excel — dd/mm/yyyy, 29 Sep 2026, day names — with Ctrl+1 and custom codes, and fix dates that refuse to change because they are text.

September 29, 2026

Formatting

How to Lock the Top Row in Excel so it stays while you scroll

Lock the top row in Excel with Freeze Top Row, lock two rows or a column too, and the difference between locking for scrolling and locking for editing.

September 29, 2026