How to turn off Excel "Header Row" without losing data in it?
Fresh3 days ago
Mar 15, 202669577 viewsConfidence Score0%
0%
Problem
I've been sent an Excel spreadsheet with a weird first row. Some of the cells say "Column1", "Column2", etc., but I can't delete their contents. If I select the cell and hit backspace, it goes blank, but when I press return, it goes right back to saying "Column1". I found another answer here that s…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How to turn off Excel "Header Row" without losing data in it?
Low Risk
The person who sent me the file (who is an Excel master) showed me the solution just now: Select All, right-click, Table -> Convert to Range.
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix