Site blog

Anyone in the world

Google Sheets is a software just like Docs to compete with Microsoft Word and Sheets. Google Sheet is based on the web that can be opened in your preferred browser and shared with multiple people. In the Google Sheet, there few things that are best for starters, and one of them is swapping the tables. Swapping the tables in the sheet is an important feature and also a useful feature for the users. To know about this feature, there is a straightforward guide for quick access.

sheets-columns11

How to Swap Columns In Google Sheets

Well, if you know nothing about it, then you should know that there are three major methods of swapping the columns by adding on Power Tools. Every method is convenient, so you understand it way too easily.

Swap the Columns through Dragging

Begin with a blank sheet with Column 1 and Column 2 with A and B columns. Input Months name the following order in the A2, A3, A4, and A5. Enter some random numbers on the cell number B2 to B5. Whatever you put in the table, it will not matter at all; it is just for the idea and understands of yours.

  • Press on the Header A and choose it.
  • Tap on the Column A header bar again and keep on hold the left mouse button.
  • Begin the drag over the Column B to swap the column table.

Now both column will change their position accordingly. Just like the same way, you can swap many more tables instantly without any additional efforts. You can also swap multiple columns together in one term by selecting the specific columns in once and drag them to the column of your choice. The following columns will change their positions, but their heading name will remain the same.

Swap the Column Table in Google Sheet through Copy and Paste

Another method to swap the table is through the Copy and Paste method. This method is different from the drag method yet a simple method. To do the swapping through copy and paste, you need to first choose the column to swap.

  • Select the column and copy that specific column table.
  • Paste that particular column on the empty column of the sheet area.
  • You can do copy and paste by using the commands as well.

In the same method, you can choose any column to swap. Even if you are willing to swap multiple, you need to select multiple columns at once and paste them on the black area of sheet to swap. Columns will change their positions, but you need to remember every column that you copy and paste while doing it. This procedure is different swap is different and can take time to do that as well. If you successfully swap the columns, so don’t forget to delete the duplicate columns by pressing Del key to remove the table.

Swap the Columns through Power Tool

Google Sheet has several adds-on for enhancing its compatibilities, and power tool are one of these enhancements of capability add-on. To add the power tool into the Google Sheet, tap on Add-ons>Power Tools>Start. Through this, a sidebar will keep on showing. Tap on the Data and the Shuffle icon to get the options to move the columns. With the feature, you can swap the columns easily. Choose the full column to move and then hold on the A column to drag it on the B column and then tap on the shuffle button to swap both columns.

Google Sheet is an alternative software that is just like Microsoft Excel, and you can get a few great features in it as well. Whoever learns the features of Google Sheet only uses it. However, both are not so different from each other.

 

Source: https://smnorton.com/how-to-swap-the-columns-in-the-google-sheets/

 
Picture of marie robert
by marie robert - Tuesday, 17 March 2020, 4:13 AM
Anyone in the world

If you are working on the quick financial spreadSheets or you need to work together with the partner on the Excel file. Google Sheets is the best web-based and free substitute to Excel, which is used by a large number of users all around the globe to place data into files, share and also view it, and utilize maths to follow the particular content with the spreadSheets. The significant aspect of the spreadSheets is how manageable they are. It can be used as the calculation machine, database, platform to execute the statistical task as the media library,  text editor, or to-do list, and much more.

The chances are a lot; however, the most ordinary use of the spreadSheets comprising Sheets to follow the time like employee time table or the billing hours. If users are utilizing the Google Sheets to follow time in this method, then you will surely locate the importance of calculating the difference in 2 timestamps, like the time utilized between 2-time events.

For instance, if anyone punches on 9:15 am and punch out at 4:30 pm, they are in clock for about 8  hours and 15 min. If you want to utilize it for anything specific, you will instantly notice that it will be created for managing such work. Even when it is not created particularly to manage features like these, it is simple to convince it to execute it with some plans. If you want to calculate time in Google Sheets, then you are on the right post. Read the blog and follow the instructions to execute it.

How to Calculate Time in Google Sheets

Calculating the difference of 2 cells, including the time information needs as Sheets, interpret that file in cells is the moment information. Else it may measure between 9:00 am as well as 10:00 am as 100 instead of  60 mins and an hour.  To execute it, columns of time need to format as the Time or column of duration requires to format as the Duration.

If you want to calculate time in Google Sheets, then you can follow the provided steps:

  1. Launch the Google Sheets.
  2. Click on the initial time column and then select the 123 format dropdown in the section.
  3. Choose the Time as a format option.
  4. Repeat the same for the second column of time.
  5. Format column of duration as the Duration similarly.
  6. Then the columns are format properly to calculate the beyond time between the 2 saved timestamps.

For instance, the In time is in Column A starting at A2, and the Out time is in column C starting at C2. The number of hours worked is in column E. As the formats set properly, the calculation will not be simple. You have to follow the formula C2 – A2. This will show the elapsed time between 2 cells and appears as the hours.

Final Instance

Google Sheets was originally not created for making timeSheets; however, it can seem to configure for that. The ordinary customization means that you may follow the working hours more easily and conveniently. As the time spans pass over the 24-hour limit, it becomes complicated; however, Sheets still can be gathered by modifying from date format to Time.

Source url:-https://williamsblogpoint.wordpress.com/2020/03/17/how-to-calculate-time-in-google-sheets/