Home |
Search |
Today's Posts |
#4
![]() |
|||
|
|||
![]()
Anne,
The button you describe is the Merge and Center button, and is considered more trouble than it's worth. You have trouble with selections, pasting, getting seeds out of your teeth -- all kinds of stuff, which shows up later long after you've forgotten you even used merge and center. Better is Bob's suggestion of Format - Cells - Alignment - Center across selection. You select the cells (that you'd have merged), then use that command. Put the stuff you want to appear in the selected range into the leftmost cell. -- Earl Kiosterud www.smokeylake.com/ ------------------------------------------- "Anne Troy" wrote in message news:5d9b8$42c2e954$97c5108d$14895@allthenewsgroup s.com... Ravi: On the formatting toolbar there's a button that looks something like this: <-A- Select your cells and HIT IT! ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Ravi" wrote in message ... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Counting empty cells within a range of cells | New Users to Excel | |||
How can I dynamically eliminate blank cells in a given range in E. | Excel Worksheet Functions | |||
How do you delete one cell from a range of protected cells | Excel Worksheet Functions | |||
Excel-value in a range of cells for two cross references | Excel Worksheet Functions |