Solved

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

Posted on 2003-11-15
12
557 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
  • 4
  • 4
  • 2
  • +1
12 Comments
 
LVL 44

Expert Comment

by:CrazyOne
Comment Utility
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
Comment Utility
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
Comment Utility
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
 
LVL 4

Expert Comment

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

Must read ALL the words in future.
0
 

Author Comment

by:GMartin
Comment Utility
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
Comment Utility
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
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
LVL 18

Expert Comment

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

Expert Comment

by:chicagoan
Comment Utility
CTRL LEFT CLICK each cell
0
 

Author Comment

by:GMartin
Comment Utility
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
Comment Utility
without releasing the CTRL key?
0
 

Author Comment

by:GMartin
Comment Utility
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
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Moving your enterprise fax infrastructure from in-house fax machines and servers to the cloud makes sense — from both an efficiency and productivity standpoint. But does migrating to a cloud fax solution mean you will no longer be able to send or re…
This paper addresses the security of Sennheiser DECT Contact Center and Office (CC&O) headsets. It describes the DECT security chain comprised of “Pairing”, “Per Call Authentication” and “Encryption”, which are all part of the standard DECT protocol.
This video discusses moving either the default database or any database to a new volume.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now