-
توجه: در صورتی که از کاربران قدیمی ایران انجمن هستید و امکان ورود به سایت را ندارید، میتوانید با آیدی altin_admin@ در تلگرام تماس حاصل نمایید.
آموزش Google Spreadsheets-En
- شروع کننده موضوع A M I R
- تاریخ شروع
[h=2]Modifying Columns, Rows, and Cells
[h=4]To Merge Cells:
Select the cells you wish to merge. In this example, we are selecting cell range A1
1.
Locate and select the Merge cells button
.
The cells will now be merged into a single cell.
To unmerge a cell, click the drop-down arrow next to the Merge cells button and then select Unmerge cells from the drop-down menu.
Select the cells you wish to merge. In this example, we are selecting cell range A1
1.
Locate and select the Merge cells button
The cells will now be merged into a single cell.
To unmerge a cell, click the drop-down arrow next to the Merge cells button and then select Unmerge cells from the drop-down menu.
[h=2]Modifying Columns, Rows, and Cells
[h=3]Freezing Rows and Columns
When working with large spreadsheets, there will be times when you'll want to see certain
rows or columns all the time, especially when using header cells as in our example
below. By freezing rows or columns in place, you'll be able to scroll through your
spreadsheet while continuing to see the header cells
When working with large spreadsheets, there will be times when you'll want to see certain
rows or columns all the time, especially when using header cells as in our example
below. By freezing rows or columns in place, you'll be able to scroll through your
spreadsheet while continuing to see the header cells
[h=2]Modifying Columns, Rows, and Cells
[h=4]To Freeze a Row:
You can freeze up to ten rows at the top of a spreadsheet.
Locate the row or rows you wish to freeze. In this example, we will freeze the top two rows.
Locate and click View in the Toolbar Menu. Hover the mouse over Freeze rows and then
select the desired number of rows to freeze from the drop-down menu
The top two rows are frozen in place. You can scroll down your worksheet while continuing to view the frozen rows at the top.
You can freeze up to ten rows at the top of a spreadsheet.
Locate the row or rows you wish to freeze. In this example, we will freeze the top two rows.
Locate and click View in the Toolbar Menu. Hover the mouse over Freeze rows and then
select the desired number of rows to freeze from the drop-down menu
The top two rows are frozen in place. You can scroll down your worksheet while continuing to view the frozen rows at the top.
[h=2]Modifying Columns, Rows, and Cells
[h=3]Freezing Rows and Columns
When working with large spreadsheets, there will be times when you'll want to see certain
rows or columns all the time, especially when using header cells as in our example
below. By freezing rows or columns in place, you'll be able to scroll through your
spreadsheet while continuing to see the header cells
When working with large spreadsheets, there will be times when you'll want to see certain
rows or columns all the time, especially when using header cells as in our example
below. By freezing rows or columns in place, you'll be able to scroll through your
spreadsheet while continuing to see the header cells
[h=2]Modifying Columns, Rows, and Cells
[h=4]To Freeze a Row:
You can freeze up to ten rows at the top of a spreadsheet.
Locate the row or rows you wish to freeze. In this example, we will freeze the top two rows.
Locate and click View in the Toolbar Menu. Hover the mouse over Freeze rows
and then select the desired number of rows to freeze from the drop-down menu
The top two rows are frozen in place. You can scroll down your
worksheet while continuing to view the frozen rows at the top
You can freeze up to ten rows at the top of a spreadsheet.
Locate the row or rows you wish to freeze. In this example, we will freeze the top two rows.
Locate and click View in the Toolbar Menu. Hover the mouse over Freeze rows
and then select the desired number of rows to freeze from the drop-down menu
The top two rows are frozen in place. You can scroll down your
worksheet while continuing to view the frozen rows at the top
[h=2]Modifying Columns, Rows, and Cells
[h=4]To Freeze a Column:
You can freeze up to 5 columns on the left-hand side of a spreadsheet.
Locate the column or columns you wish to freeze. In this example, we will freeze the leftmost column.
Locate and click View in the Toolbar Menu. Hover the mouse over Freeze columns and then
select the desired number of columns to freeze from the drop-down menu
The leftmost column is now frozen in place. You can scroll across your worksheet while continuing to view the frozen column on the left.
To unfreeze rows, click View in the Toolbar Menu, hover the mouse over Freeze rows
and then select No frozen rows. To unfreeze columns, click View in the Toolbar
Menu, hover the mouse over Freeze columns and then select No frozen columns
You can freeze up to 5 columns on the left-hand side of a spreadsheet.
Locate the column or columns you wish to freeze. In this example, we will freeze the leftmost column.
Locate and click View in the Toolbar Menu. Hover the mouse over Freeze columns and then
select the desired number of columns to freeze from the drop-down menu
The leftmost column is now frozen in place. You can scroll across your worksheet while continuing to view the frozen column on the left.
To unfreeze rows, click View in the Toolbar Menu, hover the mouse over Freeze rows
and then select No frozen rows. To unfreeze columns, click View in the Toolbar
Menu, hover the mouse over Freeze columns and then select No frozen columns
[h=2]Formatting Cells
[h=3]Introduction
After you've added a lot of content to a spreadsheet, it can sometimes be difficult
to view and read all of your information easily. Formatting allows you to customize
the look and feel of your spreadsheet, making it easier to view and understand
In this lesson, you'll learn how to modify the size, style and color of text
in your cells. You will also learn how to set text alignments, and how
to add borders and background colors to your cells
After you've added a lot of content to a spreadsheet, it can sometimes be difficult
to view and read all of your information easily. Formatting allows you to customize
the look and feel of your spreadsheet, making it easier to view and understand
In this lesson, you'll learn how to modify the size, style and color of text
in your cells. You will also learn how to set text alignments, and how
to add borders and background colors to your cells
[h=3]Formatting Cells
[h=3]Formatting Cells
Every cell in a new spreadsheet uses the same default formatting. As you
begin to build a spreadsheet, you can customize the formatting to make your
information easier to view and understand. In our example, we will be using
a spreadsheet to plan and organize a garden plot.
Every cell in a new spreadsheet uses the same default formatting. As you
begin to build a spreadsheet, you can customize the formatting to make your
information easier to view and understand. In our example, we will be using
a spreadsheet to plan and organize a garden plot.
[h=2]Formatting Cells
[h=4]To Change the Font Size:
Modifying the font size can help call attention to important cells and make them
easier to read. In our example, we will be increasing the size of our header cells
to help distinguish them from the rest of the spreadsheet
Select the cell or cells you wish to modify.
Locate and select the Font Size button
in the Shortcut Toolbar
and then choose the desired font size from the drop-down menu. In our
example, we will choose 14pt to make the text larger
The text will change to the new font size.
Modifying the font size can help call attention to important cells and make them
easier to read. In our example, we will be increasing the size of our header cells
to help distinguish them from the rest of the spreadsheet
Select the cell or cells you wish to modify.
Locate and select the Font Size button
and then choose the desired font size from the drop-down menu. In our
example, we will choose 14pt to make the text larger
The text will change to the new font size.
[h=2]Formatting Cells
[h=4]To Change the Font Style:
While Google Spreadsheets does not offer many choices, choosing a different font style
can help to further separate certain parts of your spreadsheet, like the header cells, from the rest of your information
Select the cell or cells you wish to modify.
Locate and select Format in the Toolbar menu.
Hover the mouse over Font and then select a new font style
from the drop-down menu. In our example, we will select Georgia
The text will change to the new font style.
While Google Spreadsheets does not offer many choices, choosing a different font style
can help to further separate certain parts of your spreadsheet, like the header cells, from the rest of your information
Select the cell or cells you wish to modify.
Locate and select Format in the Toolbar menu.
Hover the mouse over Font and then select a new font style
from the drop-down menu. In our example, we will select Georgia
The text will change to the new font style.
[h=2]Formatting Cells
[h=4]To Change the Text Color:
Select the cell or cells you wish to modify.
Locate and select the Text color button
in the Shortcut Toolbar.
A drop-down menu of different text colors will appear.
Select the color you wish to use. In our example, we will select red.
The text will change to the new color.
[h=4]To Change the Text Color:
Select the cell or cells you wish to modify.
Locate and select the Text color button
A drop-down menu of different text colors will appear.
Select the color you wish to use. In our example, we will select red.
The text will change to the new color.
[h=2]Formatting Cells
[h=4]To Make Text Bold:
Select the text you wish to modify.
To bold text, click the Bold text button
or press Ctrl+B (Windows) or Command+B (Mac) on your keyboard.
The text will change to bold.
Press Ctrl+I (Windows) or Command+I (Mac) on your keyboard to add italics. Press
Ctrl+U (Windows) or Command+U (Mac) to add underlining
Select the text you wish to modify.
To bold text, click the Bold text button
The text will change to bold.
Press Ctrl+I (Windows) or Command+I (Mac) on your keyboard to add italics. Press
Ctrl+U (Windows) or Command+U (Mac) to add underlining
[h=2]Formatting Cells
[h=3]Text Alignment
By default, any text entered into your spreadsheet will be aligned to the bottom left
of a cell. Any numbers will be aligned to the bottom right of a cell. Changing the
alignment of your cell content allows you to choose where the content will appear in any cell
[h=3]Text Alignment
By default, any text entered into your spreadsheet will be aligned to the bottom left
of a cell. Any numbers will be aligned to the bottom right of a cell. Changing the
alignment of your cell content allows you to choose where the content will appear in any cell
[h=2]Formatting Cells
[h=4]To Modify the Horizontal Text Alignment:
Select the text you wish to modify and then click the Align button
in the Shortcut Toolbar.
Select the desired alignment from the top of the drop-down menu.
The text will realign.
Select the text you wish to modify and then click the Align button
Select the desired alignment from the top of the drop-down menu.
-
Left align: Aligns content to the left border of the cell.
-
Center align: Aligns content an equal distance from the left and right borders of the cell.
-
Right align : Aligns content to the right border of the cell.
The text will realign.
[h=2]Formatting Cells
[h=4]To Modify the Vertical Text Alignment:
Select the text you wish to modify and then click the Align button
in the Shortcut Toolbar.
Choose the desired alignment from the drop-down menu.
The text will realign.
You can apply both vertical and horizontal alignment settings to any cell.
[h=4]To Modify the Vertical Text Alignment:
Select the text you wish to modify and then click the Align button
Choose the desired alignment from the drop-down menu.
-
Top align: Aligns content to the top border of the cell.
-
Center align: Aligns content an equal distance from the top and bottom borders of the cell.
-
Bottom align: Aligns content to the bottom border of the cell.
The text will realign.
You can apply both vertical and horizontal alignment settings to any cell.
[h=2]Formatting Cells
[h=4]To Add Cell Borders:
Select the cell or cells you wish to modify
Locate and select the Borders button
from the Shortcut Toolbar.
Choose the desired border option from the drop-down menu. In our example, we will choose to display all cell borders
The new cell borders will appear.
[h=4]To Add Cell Borders:
Select the cell or cells you wish to modify
Locate and select the Borders button
Choose the desired border option from the drop-down menu. In our example, we will choose to display all cell borders
The new cell borders will appear.
[h=2]Formatting Cells
[h=4]To Change the Text Background Color:
It's easy to change the background color of any cell, which is known as the text background color.
Select the cell or cells you wish to modify.
Locate and select the Text background color button
from the Shortcut Toolbar.
Select a color from the drop-down menu. In our example, we'll choose blue.
The new text background color will appear.
You can also use text background color to represent different kinds of
information. In our example below, each seed planted in the garden is
represented by a different background color
[h=4]To Change the Text Background Color:
It's easy to change the background color of any cell, which is known as the text background color.
Select the cell or cells you wish to modify.
Locate and select the Text background color button
Select a color from the drop-down menu. In our example, we'll choose blue.
The new text background color will appear.
You can also use text background color to represent different kinds of
information. In our example below, each seed planted in the garden is
represented by a different background color
[h=2]Formatting Cells
[h=3]Formatting Text and Numbers
The ability to apply specific formatting for text and numbers is one of the most powerful
tools in Google Spreadsheets. Instead of displaying all cell content in exactly the same
way, you can use formatting to change the appearance of
dates, times, decimals, percentages (%), currency ($), and much more
[h=3]Formatting Text and Numbers
The ability to apply specific formatting for text and numbers is one of the most powerful
tools in Google Spreadsheets. Instead of displaying all cell content in exactly the same
way, you can use formatting to change the appearance of
dates, times, decimals, percentages (%), currency ($), and much more