I am trying to format my resume into excel, so everything lines up. I'd like to make a row at the top for my header, but not have any columns for that top row only. How do I do this?
Steph
I am trying to format my resume into excel, so everything lines up. I'd like to make a row at the top for my header, but not have any columns for that top row only. How do I do this?
Steph
You can line everything up in Word, too, by using the various tab positions/settings and alignment.
As for Excel, and your problem, select all of the cells that make up 1 page width and click the Merge & Center button on the toolbar. It's usually just right of the Right Alignment button.
Or, select the cells and choose Format->Cells.. and on the Alignment tab, check the box next to 'Merge Cells', and set the Horizontal alignment to Center.
Hi, Steph. There is really no way to get rid of the columns. However, you can merge the cells, so that the first row appears to not have a column.
Highlight the cells in the first row that are the width of your resume. Select Fomat > Cells from the menu, select the Alignment tab, and check Merge Cells.
HTH
Jason
Paul, this cold weather is really slowing up my Internet connection! LOL
select cells a1 to g1 - change g1 to suit
Format cells
Alignment tab
Tick merge cells
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assisted or failed to assist you I welcome your Feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks