Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
table format
I want to set up something akin to a table in Word where if you have the last
cell highlighted and you push tab it creates another row with all the same borders. Is there a way to do something like that in Excel without recording a macro? I just want to be able to extend my data by a row and to keep border formatting. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
table format
For the future, please post WOrd questionsin the Word forum to get the best
advice. But here is the answer anyway. Place your cursor at the very right of (outside) the last cell in the row, and hit Enter. That should do it. "rcc" wrote: I want to set up something akin to a table in Word where if you have the last cell highlighted and you push tab it creates another row with all the same borders. Is there a way to do something like that in Excel without recording a macro? I just want to be able to extend my data by a row and to keep border formatting. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I format a pivot table column - permanently? | Excel Discussion (Misc queries) | |||
How to convert a Pivot Table into a Flat File format? | Excel Discussion (Misc queries) | |||
Pivot Table Row Field Format (OLAP Source) | Excel Discussion (Misc queries) | |||
Linking table in Excel to word | Links and Linking in Excel | |||
How Do You Permanently Format Fields of a Pivot Table? | Excel Discussion (Misc queries) |