EnglishEspañolBahasa IndonesiaPусскийукраїнська моваTiếng ViệtFormatting a spreadsheet is really about adding style so that your data is easy to read and interpret, When a spreadsheet is properly formatted, you can glance over the data and understand it much more quickly than flat data alone" /> EnglishEspañolBahasa IndonesiaPусскийукраїнська моваTiếng ViệtFormatting a spreadsheet is really about adding style so that your data is easy to read and interpret, When a spreadsheet is properly formatted, you can glance over the data and understand it much more quickly than flat data alone" />

Định dạng ngày tháng trong google sheet

Difficulty:BeginnerLength:MediumLanguages:url-selector#selectionChanged" data-controller="url-selector">EnglishEspañolBahasa IndonesiaPусскийукраїнська моваTiếng Việt

Formatting a spreadsheet is really about adding style so that your data is easy lớn read & interpret. When a spreadsheet is properly formatted, you can glance over the data & underst& it much more quickly than flat data alone.

Bạn đang xem: Định dạng ngày tháng trong google sheet

*
With a bit of formatting, it"s much easier khổng lồ read a spreadsheet and find meaning inside of it.

Use formatting in Google Sheets to lớn make it easy to read and collaborate on spreadsheets, right inside of a website browser. Here are just a few of the formatting tools that we"ll cover in this tutorial:

Bold cells draw a viewer"s attention & let them know that the data in a selected cell is more important than the surrounding Google cells.Alignment, which allows you khổng lồ put the content lớn the left, center, or right side of a cell, creates natural whitespace that makes a spreadsheet easier lớn read.Text wrapping can help oversized blocks of text fit in a single cell without wrapping & extending to lớn additional cells.

In this tutorial, I"m going to lớn jump around and show you all of the essential skills you need khổng lồ format Google spreadsheets. You"ll learn how lớn edit Google Sheets with essential formatting for easy reading. Let"s jump in!

*

How khổng lồ Edit Google Sheets (Watch & Learn)

In the screencast below, I"ll give you an "over the shoulder" look at how I handle formatting a raw spreadsheet in Google Sheets. You"ll get a chance to see how I think about adding styles & formatting to lớn emphaform size cells.


*


Keep reading lớn see an illustrated guide for creating great-looking Sheets. 

How to Format Data 

One of the most important parts of formatting Google cells is making sure that your data has the correct format for the type of data it holds. Even though they"re both numerical values, you would a dollar amount, & the number of items your purchased to lớn be formatted differently.

This is why formatting matters. When I glance at a number, I should at least have sầu a basic idea of what type of data we might be talking about. Let"s look at some tweaks you can apply lớn data to lớn make it more understandable.

1. Currency Formatting

Spreadsheets often hold financial information, so it makes sense that formatting should show that. While "$504.53" clearly refers lớn a currency amount, "504" in a cell isn"t as intuitive sầu. That"s why formatting numbers as currency is so useful.

To format data, always start off by clicking & highlighting the data that you want lớn apply the format to. In the example screenshot below, both the "Amt" and "Hourly" columns would benefit from currency formatting. Then, click on the dollar sign just above sầu the data to lớn apply currency formatting khổng lồ the entire selection.

*
With your financial amounts selected, find the currency symbol on the toolbar & cliông chồng on it to style your data accordingly.

This is a perfect example of how formatting makes a spreadsheet more meaningful. The currency symbols quickly give the clues to the user that these amounts are more than simple numbers.

For our readers in other regions, don"t miss out on the fact that you can change the currency symbol that"s presented. With your data highlighted, clichồng on the 123 icon, và then choose More Formats > More Currencies as you can see in the screenshot below.

*
From the 123 (number formatting) thực đơn option, choose More Formats > More Currencies to select a new currency symbol to add to lớn your data.

Choose another currency symbol to lớn localize your Google spreadsheets. Just rethành viên that this doesn"t automatically convert the amounts, it simply changes the currency symbol.

For our readers in other regions, don"t miss out on the fact that you can change the currency symbol that"s presented.

2. Decimal Points

You might also want khổng lồ tweak the number of decimal points that show in your spreadsheet. There are really two key scenargame ios that this comes in handy:

Your data has decimal amounts in it, but you don"t want to show them in the cell for simplicity"s sake. (For example, who typically cares about 24 cents at the end of $1,000,000 in a cell?)Decimal points are showing in your data, but you"re working with data that shouldn"t be fractional. (0.4 people can"t be finished with a project, but someone could be 40% finished)

In either case, you can tweak the number of decimal points that are showing in the spreadsheet.

This illustrates an important concept about spreadsheets: the data that"s behind the scenes can differ from how you"re viewing it. You can always cliông xã in a cell và kiểm tra the formula bar, as you can see in the screenshot below, to lớn check the real value of a cell.

*
As you can see in this screenshot, the cell appears to be $1,100, while the underlying data has a decimal amount as shown in the formula bar.

To change the number of decimal points that you see showing in the cell, find the icons highlighted in the screenshot below, just above the spreadsheet. Highlight the cells you want to lớn tweak, then click the appropriate cell lớn either increase or decrease the number of decimal points showing.

Xem thêm: Các Hình Thức Thanh Toán Internet Fpt Tại Tp, Các Hình Thức Thanh Toán Cước Internet Fpt

*
Cliông chồng one of the two icons highlighted in the screenshot above to increase (left) or decrease (right) the number of decimal figures showing for your data.

Don"t forget that you can also use one of the starter styles from the number dropdown to skip styling each cell one-by-one.

3. Date Formats

You don"t have to re-type the data as simple text in the desired format. You can simply change up the formatting và how the data is presented. Highlight your date data, & then access the Format > Number > More Formats > More date & time formats... option as you can see in the screenshot below. 

*
Open the date formatting options by highlighting your data and navigating to lớn the More date and time formats... option.

This pop-up thực đơn really allows you to lớn customize the way that you"ll format your date data. There are plenty of pre-built options that you can choose from the các mục as the screenshot below shows.

*
Choose one of the pre-built styles to start with a date style, then customize individual parts using dropdown options.

Use one of the date formats as a starting point, then tweak it using a dropdown for the exact style you"re looking for.

How to Align Data in Google Sheets 

Text alignment describes what edge of the cell that the content aligns with. To apply alignment, simply highlight the text, and use the alignment dropdown that I show in the screenshot below.

*
Choose one of the alignment options to lớn left align, center, and right align text inside of a cell.

Numeric values are often easier khổng lồ read when right-aligned, while text is usually easier when it"s left-aligned. 

How lớn Format Google Spreadsheets With Borders

Borders, lines applied khổng lồ the edge of Google cells, can really help you separate your data và make it stvà out from the crowd.

In the example below, you"ll see me apply borders by highlighting data and choosing a border from the dropdown option. The icons each represent a border option you can apply khổng lồ data, whether you want khổng lồ draw lines between each và every cell, or simply surrounding your data on the outer edges.

*
Applying a border lớn your data can make it easier lớn read data, & you can apply a variety of border styles with the dropdown option in this screenshot.

I think that borders have sầu a great way of really setting data off và make it readable. I also lượt thích to use borders when I have sầu a standalone data box separate from my data, such as an "inputs" box where I set the key data used in formulas.

Bonus Tip: How to Use the Format Painter

So far, you might have sầu been applying formats one-by-one, cell-by-cell. A solution that will save you many hours of applying formats is the format painter. Thanks khổng lồ this feature, you can easily take a format và apply it khổng lồ other cells.

To start using the format painter, start off by clicking in a cell that you want khổng lồ copy the format from. Next, find the paint roller ibé on the thực đơn, và cliông xã on it.

*
Clichồng on the cells that you want to copy the format from, then the Format Painter, then the cells you want to lớn paste the styles lớn.

Now, simply click and drag over any Google cells that you want to lớn take on the same style. Those cells will take on the same style as the source.

Recap & Keep Learning

Google Sheets proves once again that it"s a more-than-capable replacement for spreadsheet apps with plenty of formatting options. You"ve sầu just learned how to edit Google Sheets and format Google spreadsheet cells. Remember while you"re applying formatting, that it"s all about the nội dung. Formatting is just the icing on the cake that draws attention to the right places.

If this tutorial got you interested in using Sheets, don"t miss the tutorials below khổng lồ learn more:

What are your favorite formatting tweaks to apply? Let me know in the comments section below if you"ve got any tips on how khổng lồ format Google spreadsheets to lớn share.