Welcome Guest
Log In | Register )
You last visited December 9, 2016, 9:55 pm
All times shown are
Eastern Time (GMT-5:00)

Need help with Excel

Topic closed. 33 replies. Last post 12 years ago by honey bee.

Page 2 of 3
PrintE-mailLink
johnph77's avatar - avatar
CA
United States
Member #2987
December 10, 2003
832 Posts
Offline
Posted: January 19, 2005, 8:07 am - IP Logged

At the toolbar on the top:

Format>Column>Width

will permit you to adjust the column width for the entire spreadsheet, less those individual columns you have already adjusted.

gl

john

Blessed Saint Leibowitz, keep 'em dreamin' down there..... 

Next week's convention for Psychics and Prognosticators has been cancelled due to unforeseen circumstances.

 =^.^=

    Maverick's avatar - yinyang
    USA
    United States
    Member #8242
    October 29, 2004
    1133 Posts
    Offline
    Posted: January 19, 2005, 4:49 pm - IP Logged

    Yes, that's where I went yesterday. I typed in 1 in the box and clicked OK. But that still only lessened one box, not the whole spreadsheet. Thanx for the help though.

      undress's avatar - Lottery-061.jpg
      roseville, MI
      United States
      Member #5980
      July 30, 2004
      18205 Posts
      Offline
      Posted: January 19, 2005, 4:51 pm - IP Logged

      Highlight the boxes you want to change the go to format cells width type in the width you want. Bingo.

      Mad ALL IN!Mad

        Maverick's avatar - yinyang
        USA
        United States
        Member #8242
        October 29, 2004
        1133 Posts
        Offline
        Posted: January 19, 2005, 5:03 pm - IP Logged

        Ahh, sweeeeeeeeeeeeeeeeeeeeeet! Thanx undress

          Avatar
          Pretoria
          South Africa
          Member #6062
          August 4, 2004
          54 Posts
          Offline
          Posted: January 20, 2005, 2:19 am - IP Logged

          Maverick,

          If you want to do the whole worksheet, you must first highlight it by clicking on the box on the top left hand side (above row 1 and left of column A.

          Cheers,

          Datenda

          Tata Syndicate Boss

            Maverick's avatar - yinyang
            USA
            United States
            Member #8242
            October 29, 2004
            1133 Posts
            Offline
            Posted: January 20, 2005, 1:09 pm - IP Logged

            Thanx for the additional help Datenda

              four4me's avatar - gate1
              MD
              United States
              Member #1701
              June 18, 2003
              8364 Posts
              Offline
              Posted: January 20, 2005, 1:45 pm - IP Logged

              Mav something to think about is making a workbook or sheet and call it practice sheet then you won't lose any data you have by mistakes. In the practice worksheet you can copy and paste info there and try the things you want to do. When you get a handle on the different features and get the sheet to look like you want, then you can transfer the info to the original worksheet. 

                Maverick's avatar - yinyang
                USA
                United States
                Member #8242
                October 29, 2004
                1133 Posts
                Offline
                Posted: January 20, 2005, 1:49 pm - IP Logged

                Cool, thanx for the idea Four4me

                  honey bee's avatar - animaniacs40
                  VA.
                  United States
                  Member #2362
                  September 21, 2003
                  3020 Posts
                  Offline
                  Posted: February 2, 2005, 5:44 pm - IP Logged

                  Can any one tell me how to made the lines

                  darker in excel

                    SirMetro's avatar - center
                    East of Atlanta
                    United States
                    Member #6191
                    August 11, 2004
                    1389 Posts
                    Offline
                    Posted: February 2, 2005, 11:19 pm - IP Logged

                    In excel, right mouse click the selected cells, then select "FORMAT CELLS" and in the next window, select "BORDERS"

                    You can then define the line weight (thickness), color, appearance, etc...

                    Sir Metro

                    PS: A great, inexpensive help is a book called Excel for Dummies, well written with pictures to help guide you. Found at most book stores, Walmart, etc...

                      honey bee's avatar - animaniacs40
                      VA.
                      United States
                      Member #2362
                      September 21, 2003
                      3020 Posts
                      Offline
                      Posted: February 3, 2005, 8:55 am - IP Logged

                      Thank you SirMetro

                        hypersoniq's avatar - 8ball
                        Pennsylvania
                        United States
                        Member #1340
                        April 6, 2003
                        2450 Posts
                        Offline
                        Posted: February 3, 2005, 9:13 pm - IP Logged
                        Quote: Originally posted by Maverick on January 18, 2005




                         About the numbers that originally appear on the left side going downwards, can I delete the numbers and put in my own numbers or letters? Same question for the original letters that appear on top going across.





                        the original numbers and letters are the cell address components, the alpha portion = column and the numeric portion = row... for example, column C is the third one over, row 5 is the fifth one down, cell C5 is 3 over and 5 down... this is known as cell addressing and is the basis for excel so they cannot be changed.

                        here is a simple intro to the basics of cell addressing and formula creation...

                        in the first cell (A1) type      9

                        in the cell below that one (A2) type        3

                        in the cell below that type      =A1-A2

                        once you hit enter, the =A1-A2 calculates the result, 6

                        now here is where the fun and power of excel kick in... in cell A1, change the 9 to a 12

                        the formula is using cell addressing rather than fixed numbers, so it automatically changes to reflect the new data.

                        Forgive me if that sounded too basic, but addressing is the key to much more complex formulas later on....

                        now step 2, absolute versus relative addressing...

                        in your example file, in cell B1, put a 5, then in C1 put a 7

                        in cell B2 put a 1 and in cell C2 put a 4

                        now, move the mouse to the bottom right corner of cell A3, you have it right when the pointer changes to a  +  . now drag it over to cell C3... note how all the right answers are under the right columns?  that's the power of "autofill". note the formulas in each of the 3 cells in row 3 have changed themselves to =B1-B2 and =C1-C2, respectively?

                        that's a relative address... it's like saying... make a left 2 stoplights from city hall... how many towns would those instructions work in?

                        an Absolute address is an exact cell reference, this will NOT change even if you autofill the formula, it's like saying 123 main street, anytown, CA, 90210.... it specifies an exact place.

                        let's work that in to the example.... in cell D1, enter a 10

                        now, in cell A3, modify the formula to the following...  =A1-A2+$D$1

                        The dollar signs act as anchors, they will not change.... now autofill this to cell C3... and look at the formula as it appears in cell B3, it is now =B1-B2+$D$1

                        the value in D1 here represents a constant.... if you were calculating sales figures, this could represent a tax rate.

                        if you only typed =A1-A2+D$1, then the D would change in relation to that cell, now B3 would read =B1-B2+E$1  (E1 is blank).

                        each scenario can be used to your advantage once you understand the difference. just think of the $ as an anchor and you'll be fine ;-)

                        but that is why you can't change the numbers and letters along the side... (you CAN hide them, but that's another story altogether...

                        Playing more than one ticket per game is betting against yourself.

                          retxx's avatar - mrthumbs
                          BOSTON
                          United States
                          Member #48
                          September 9, 2001
                          3594 Posts
                          Offline
                          Posted: February 3, 2005, 9:28 pm - IP Logged

                          wow you sure know your excel,hope the finish product will be ready soon. Can hardly wait to try it out here. Thanks

                            Maverick's avatar - yinyang
                            USA
                            United States
                            Member #8242
                            October 29, 2004
                            1133 Posts
                            Offline
                            Posted: February 4, 2005, 1:08 am - IP Logged
                            Quote: Originally posted by hypersoniq on February 3, 2005


                            the original numbers and letters are the cell address components, the alpha portion = column and the numeric portion = row... for example, column C is the third one over, row 5 is the fifth one down, cell C5 is 3 over and 5 down... this is known as cell addressing and is the basis for excel so they cannot be changed.


                            Thanx dude
                              hypersoniq's avatar - 8ball
                              Pennsylvania
                              United States
                              Member #1340
                              April 6, 2003
                              2450 Posts
                              Offline
                              Posted: February 4, 2005, 7:40 pm - IP Logged

                              Maverick, what I usually do is use the cells in row 1 for column headings and column A cells for things such as drawing numbers or drawing dates.

                              Playing more than one ticket per game is betting against yourself.