Solved

needing instructions for centering data within A1 and B1 cells of spreadsheet

Posted on 2003-11-15
12
585 Views
Last Modified: 2010-04-26
Hi Everyone:

       I am in the process of creating a checklist using the spreadsheet utility built into Microsoft Works 7.0.  At this point, I am needing to know how to center some information which was typed into A1 and carries over into B1 cell.  

       Any information on solving this concern will be appreciated.  I look forward to reading everyone's thoughts on this one.  

       Thank you.

       George
0
Comment
Question by:GMartin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
  • 2
  • +1
12 Comments
 
LVL 44

Expert Comment

by:CrazyOne
ID: 9757293
Hi George I don't think most of use you use Microsoft Works instead we use Microsoft Office.
0
 
LVL 18

Accepted Solution

by:
chicagoan earned 300 total points
ID: 9757449
In excel you would highlight the adjoing cells right click - format - merge and center...

don't know if your version supports these features, might be better asked in the 'apps' topic area

A work around might be to put the half the text in each of the adjoining cells, right justifying A1 and left justifying B1

'your mileage may vary'
0
 
LVL 4

Assisted Solution

by:ttterk
ttterk earned 100 total points
ID: 9757467
Chicagoan is on the right track. In Works 7.0 you select both columns, go to Format>Alignment and select "Center across selection" followed by "OK" or an enter key. This is very much like Excel. I am unsure how much earlier than v.7.0 this ability is available in Works, so I hope yours is fairly recent.
0
[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

 
LVL 4

Expert Comment

by:ttterk
ID: 9757468
Just reread your post--since you have 7.0 it'll work.

Must read ALL the words in future.
0
 

Author Comment

by:GMartin
ID: 9757562
Hi,

       ok, I understand everything so far with the exception of one thing.  Could you perhaps give me the steps for selecting both columns?

       Thank you.

       George
0
 
LVL 44

Assisted Solution

by:CrazyOne
CrazyOne earned 100 total points
ID: 9757568
just put your mouse on the header of the column tht is Labeled A and then drag your mouse over to B and then let go.
0
 
LVL 18

Expert Comment

by:chicagoan
ID: 9757610
you want to select the cells...
CTRL each cell
0
 
LVL 18

Expert Comment

by:chicagoan
ID: 9757612
CTRL LEFT CLICK each cell
0
 

Author Comment

by:GMartin
ID: 9757672
Hi,

      When I left hold in the Ctrl key and use my left mouse button, it only selects one entry instead of both of them.

     George
0
 
LVL 18

Expert Comment

by:chicagoan
ID: 9757716
without releasing the CTRL key?
0
 

Author Comment

by:GMartin
ID: 9757729
Hi,

      Yes, I hold in the CTRL key while left clicking.  But, I am only able to select either A1 or B1, but, not both.  Basically, I am merely wanting to take the information typed in A1 which carried over into B1 cell and center the information to both of these cells.  In other words, I am needing to merge A1 and B1 and center the info.  I never saw an option called "merge" in Microsoft Works 7.0.  

      In closing, there is probably something I am overlooking, but any further information or tips will certainly be appreciated.

      Thank you

      George
0
 

Author Comment

by:GMartin
ID: 9757765
Hi Guys:

      I decided to create the needed columns and rows using the Table Menu with Works 7.0.  The Spreadsheet option is just too complicated.  I would need individual tutoring on creating a spreadsheet.  

      I do appreciate the feedback.

     George
0

Featured Post

Ready to trade in that old firewall?

Whether you need to trade-up to a shiny new Firebox or just ready to upgrade from whatever appliance you're using now, WatchGuard has the right appliance for you! Find your perfect Firebox today with appliance sizing tool!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Rasberry PI is a low cost piece of hardware that you can have a lot of fun with through experimenting and building/working on projects like media players, running a low cost computer, build data loggers etc. - see: https://www.raspberrypi.org
Does your iMac really need a hardware upgrade? Will upgrading RAM speed-up your computer? If yes, then how can you proceed? Upgrading RAM in your iMac is not as simple as it may seem. This article will help you in getting and installing right RA…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question