Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 7th 13, 09:36 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2012
Posts: 13
Default Help needed for inserting a row.

I am using Excel 2003.
I have a spreadsheet that has 2 Heading Rows.
The first row entries cover several columns.
The second row covers individual columns.
The formatting for the second row is for Bold and the vertical spacing is for about .5".
The vertical spacing for the other rows is about .25"
The first column is used for the date and the data is in descending date order, that is the most current date is on the top.
When I want to make a new entry I select the third row, which is the most recent date, and insert a row.
My problem is that the new row seems to take the formatting from the second row.
That is the height of the row is .5" and any data I enter is bold.
I would like the formatting for the new row to be the same as the third row.

Thanks for any and all help.

  #2   Report Post  
Old August 17th 13, 07:40 PM
Junior Member
 
First recorded activity by ExcelBanter: Aug 2013
Posts: 8
Default

Try these.

Option 1 - Copy the row. Then select the area you want to format. Right click. From the menu, select format cells. Bold is under "font" header. This is a menu to have a look around, it shows all cell format etc.

Option 2 - Insert your row, then copy & paste the row that you actually want into the new row.

Option 3 - Excel inserts a row above the one you select. So if you are on row 3 and insert, the inserted row will copy ROW 3 into that above

I know these aren't probably the best options, but as there are no previous posts, these are all I can think of to help


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting a row Pootle Excel Discussion (Misc queries) 7 February 24th 09 04:41 PM
Deleting Rows With Non-Needed Data between Needed Data Daren Excel Worksheet Functions 2 September 30th 08 06:47 PM
Inserting a row Nick C Excel Programming 3 July 15th 08 01:31 PM
Inserting Drop down on sheet - Array needed Les Excel Programming 2 July 10th 08 04:41 PM
Macro needed for inserting blank rows sunslight Excel Worksheet Functions 2 January 12th 07 05:58 PM


All times are GMT +1. The time now is 12:05 AM.

Powered by vBulletin® Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017