EXCEL Tips
Create a comment that explains a tip you have for other students who are learning and using EXCEL. Here are the guidelines:
Tip - Copy and Paste a cell's formatting only.
- Make it original. Read the comments that already have been posted.
- Make sure your tip works. Before your click on Publish, minimize this window and test your own tip.
- Take your time. Proofread your comment and check for grammar. Use complete sentences.
- Keep it simple. If your tip requires multiple steps, list them separately with enough detail.
- Follow the example below to meet the minimum expectation.
Tip - Copy and Paste a cell's formatting only.
- Click on the cell you want to copy the Formatting for.
- Right click and choose Copy.
- Click on the cell(s) you want to copy the formatting to.
- Choose Edit - Paste Special from the Standard Tool Bar.
- Choose Format Only and OK.
posted by Mr. Turton at 5:54 PM
28 Comments:
To start any type of formula you need to start it with an "=" sign or a "+" sign.
to center text within the selected cells, use the merge and center button on the formatting tool bar!
when you see #### in a cell, the number is too wide to be displayed. To widen the column to display the number, double click the right boundry of the heading!
When you're trying to Sum a bunch of numbers in either a row or column, highlight over all of them then click the 'AutoSume' button in the toolbar! It'll sum your numbers for you!
To change a number to currency with two decimal places real quick just click on the cell the number is in and click currency style button. (the button that is a dollar sign next to the percent sign)
To hide rows or colums, click a letter or number that the cell is called, and highlight the rows/colums that you want to hide. Then go to format, go down to either rows or columns, and click hide. To unhide them, go back to format, rows/column and rhwn click unhide!
when you use excell or any type of computer program you will want to save often. something might happen where there is a power outtage or you might kick the power coard. you will be regretting not saving often. there are many differnt ways of saving. there is CTRL S, the key right on the page or the file colomn. the CTRL S way all you have to do is key the CTRL button and also at the same time key S. There is also the button on the screen. This is in between the print and open button. last but not least there is the file dropdown. if you click on file, wich is next to edit you can scroll down to asve this way also....
i hope i filled up you memory drive with this!!!
and that was my joke of the day!!
<3 courtney patricia
When you need to sort a group of data, an easy way to do it quickly and efficiantly is to click the small icon on the top Menu bar that looks like an A and Z with an arrow pointing down. Clicking that sorts your data alphabetically.
When doing something on the computer that's important to you, and you want to save your work.. do it often by pushing "Ctrl S" because sometimes the computer could shut off or something and then you could loose your work. There is an easier way of saving your work too, by going to file, save or save as. *meg
Tip-When you want to format a cell as currency click the money sign. This will save many clikcs, which will alsi save time
To remove or add decimals to a number look to the right of the font color and press the down arrow. There you will see two diffrent icons which will allow you to increase or decrease the amount of decimals.
A tip for adding totals is that you can use the auto sum button on the tool bar
If you want o find the some of a row of numbers really quickly then use the auto sum button to help you find it alot easier
Hit Ctrl "c" for a quik copy
Topic- excel tips
To start any type of formula you need to start it with an "=" or "+" sign.
To delete a row or a column you need to right click on the cell letter on top of the spread sheet and select delete.
When you would like to sort your data you should go to sort under data then you can click Accending or Decending to put it in alphabetical order.
-Tips on entering dates and times-
The program treats the times and dates as numbers.When you type a date or time that Excel recognizes, the cell's format changes from the General number format to a built in date or time format. Dates and times are right-aligned in a cell. If Excel cannot recognize the date or time format, the date or time is entered as text, which is left-aligned in the cell.
-left click on the cell that has the date or time im it.
-format cells
-click on date or time witch ever one you have.
-then format the date or time how you would perfer it to look.
xx britany maciejewski
To see a formula click on the cell and to sort data click on sort data and you put it in accending or deccending order alphabetically. always start formula with the = sign.
You can go to windows and hit hide to hide a column or row!
You can sort all of your data by clicking on Sort Ascending in Data, you can organize your data by ascending or descending.
When in word of course people make mistakes. If you make a mistake more than once the Replace or Ctrl+H . It will change all the words to a different word. Example: If you want to change all the strong words into strenght, use the replace and it will change all the "strong's" at once. It's a lot more useful than you think.
If you don't feel like writing in the formula in each cell you can click the small square in the bottom right of the cell and drag it down. This will make the process go a lot faster and it will make it a lot easier.
To add up the numbers in consecutive cells click the auto sum button. It looks Like an "E".
If you want to use Microsoft Excell you don't realy kneed to know that much you can just teach yoursel.
I think that Microsoft Excell is so usefull but is kind of confusing
To add numbers in consecutive cells use the auto sum function. You can use this by By clicking the buttom that looks like a "E".
If you want to know he sum of a group of numbers without using the AutoSum Feature here's a hint. Highlight the numbers you want to sum up. (If they are in various areas, hold Ctrl and click on each cell. Now look in the lower right hand corner. There is a small box that shows you the sum. It looks like this...
Sum = ###
Post a Comment
<< Home