CGS 2531 Notes Ch. 1-5
Excel Chapter 1
Edit and Clear cell contents
Clear by selecting editing group on home tab and then select clear contents
Formulas
= sign before inputting
Auto Fill
Copy contents of a cell or range of cells by dragging the fill handle(a small black plus sign)
Drag it and it copies the formulas
You can also use this for sequences such as January and quartesFor values input first 2 #’s
Displaying Cell Formulas
You press CTRL AND GRAVE ACCENT (`) BELOW ESC..Keep cell active
Press ctrl+ enter
Change Worksheet Tab Color
Click format in the cells group on the home tab, point to Tab Color and then click color
Insert, Delete, Move and Copy Worksheets
Right Click worksheet to hide it…
Copy a worksheet by pressing ctrl and dragging it to the side
Cells, Columns, and Rows
Insert a column
Right click the letter or row number for which you want to insert a new column to the left or a new row above…
Excel inserts a new column to the left so if you have data on B and you insert on B the data will move to column C and B becomes a new column
Same thing when inserting cells
Deleting
Just click on A or B or C and press delete
Column Width
Position the pointer on the vertical border between the current column and the next column,,, the drag it
To the left you decrease to the right you increase
Hide and Unhide Columns
Hide easy---- just press hidhe on what you want
Unhide
For example if column B is hidden, drag across A and C. Then select unhide
Copy
Press Esc after copying data
Copy Excel Data to other programs
Alignment
Home tab
Center main titles over allcolumns in the worksheet and you can center category titles over groups of related columns
Select the range of cells across which you want to center the title, and then click merge and center
They are merged into one cell
Indent allingmentWrap Text
Make data appear on multiple lines by adjusting the row height to fit the cell contents within the column width
Border and Filler
Select
Edit and Clear cell contents
Clear by selecting editing group on home tab and then select clear contents
Formulas
= sign before inputting
Auto Fill
Copy contents of a cell or range of cells by dragging the fill handle(a small black plus sign)
Drag it and it copies the formulas
You can also use this for sequences such as January and quartesFor values input first 2 #’s
Displaying Cell Formulas
You press CTRL AND GRAVE ACCENT (`) BELOW ESC..Keep cell active
Press ctrl+ enter
Change Worksheet Tab Color
Click format in the cells group on the home tab, point to Tab Color and then click color
Insert, Delete, Move and Copy Worksheets
Right Click worksheet to hide it…
Copy a worksheet by pressing ctrl and dragging it to the side
Cells, Columns, and Rows
Insert a column
Right click the letter or row number for which you want to insert a new column to the left or a new row above…
Excel inserts a new column to the left so if you have data on B and you insert on B the data will move to column C and B becomes a new column
Same thing when inserting cells
Deleting
Just click on A or B or C and press delete
Column Width
Position the pointer on the vertical border between the current column and the next column,,, the drag it
To the left you decrease to the right you increase
Hide and Unhide Columns
Hide easy---- just press hidhe on what you want
Unhide
For example if column B is hidden, drag across A and C. Then select unhide
Copy
Press Esc after copying data
Copy Excel Data to other programs
Alignment
Home tab
Center main titles over allcolumns in the worksheet and you can center category titles over groups of related columns
Select the range of cells across which you want to center the title, and then click merge and center
They are merged into one cell
Indent allingmentWrap Text
Make data appear on multiple lines by adjusting the row height to fit the cell contents within the column width
Border and Filler
Select