Working with rows, columns, and cells

Working with rows, columns, and cells

As the name suggests, here in this article we would be discussing one of the Basic Excel Topics that BeXpert Advanced Excel Home Tuition covers. In Excel, every worksheet is organised into a grid of rows, columns and cells. These Individual cells can also be grouped into ranges, which are just a series of cells that are strung together. All these work in coordination with each other, in order to form the basic layout of an Excel document.

Cell Addresses

Below is the diagram that shows rows, columns, cells, and ranges all in one place:
As it is clearly visible, that Excel labels columns letterwise. It is also visible that column labels are highlighted along the top of the screen: A, B, C, etc. Rows are highlighted along the screenside and organised number wise : 1,2,3 etc. At each row and column intersection is a cell, which is just one of the boxes on the grid of a worksheet. Every cell has a unique address that is a result of the column letter and the row number combination of the given cell. Like B4 cell lies at the intersection of column Band row 4. Whenever a cell is selected, you can see its address in the cell address box that is directly above the labels columns A and B.

Cell Ranges

Multiple cells could be grouped into ranges, that are an adjacent series of cells. Below screenshot is an illustration:
In above worksheet, all cells from C3 to C6 are highlighted. This can be done, by the use of colon (:) character between the first and last cells in the range, like so: C3:C6. This notation is called “Range of all cells between C3 and C6”.

Rows and Columns Manipulation

There are a lot of things that can be done for a row or column manipulation, but prior to that you must select it. To do so, click the label of that row or column at the left or the screen top:
For multiple row and column selection, select the label of one row or column and keep the mouse pressed, then drag over to select multiple:
For selection of all rows and columns in the worksheet, select the small box at the row 1 and column A intersection:
Once the rows or column selection has been done, right click their labels to bring up the row or column manipulation menu, that is visible in the below screenshot.
This menu shows a variety of functions, which you can use as you wish. Column and row resizing can be done by taking the mouse over the divider between two rows or two columns, then clicking and dragging so as to expand or contract it.

  Website : www.bexpertadvexcel.com
   
   Phone No : 8802329198

Comments

Post a Comment

Popular posts from this blog

What is Pivot Table Example?

Image
So, how does using a pivot table to perform large scale enterprise business calculations look like? Check out the below example, in which we have used the Excel tool named Pivot Table to complete the task mentioned in the earlier blog i.e. Summing sales in dollars by customer. We were able to prepare the report in a matter of few seconds based on the input data tab. Take Note of a couple of things: it has captured the data we wanted (the sum of the Total Price column, segmented by customer); it has included a comprehensive list of customers on our input sheet; and it is ready for flexible adjustments and modification (see the Pivot Table Field List dialogue on the right-hand side of the screen). We have solved our analyst's problem. Potential uses of Pivot Tables At higher levels, Pivot Tables are more effectively used to summarize the data. Beyond that, they are infinitely flexible, and applicable to a huge variety of situations. Here are some of the more example scenarios...
Read more

What are the various Formatting options available in Excel?

Image
We can have a look at the various formatting options available in Excel by selecting a cell that contains a number and from thereon heading towards the Number formatting drop-down on the Home ribbon tab: Following are the most used formatting options that are available in Excel: Number. Excel would format your input as a generic number with commas in-between the thousands digits. Currency. Excel would format your input with a currency sign in front of it and two trailing digits after the decimal point. Accounting. Similar as the Currency format, but currency sign will align to the left-hand side of the cell. Date. Excel would format the given input as a date. Note that dates in the Excel are displayed as numerical quantities. Time. Excel would format the given input as a date or time. Times are also displayed as numerical quantities in the Excel. Percentage. Excel would format the given input as a Percentage. Like, an input of 0.76 will be read as 76%. It is important to not...
Read more

Making the Pivot Table in Excel

Image
Making the Pivot Table Now that our data is set in the right format, we can move on to creating the pivot table itself. For this tutorial, we have expanded on the sample data set above, adding in some more granular detail on the items ordered, quantity, price, and date: To create a Pivot Table based off of this data, we will first place our cursor anywhere within the data set itself. Then, we will go to the Insert section on the Ribbon and select the Pivot Table option: The Create Pivot Table dialogue box will open asking us to specify some of the options. Since Excel has already selected our data and the rest of the options work by default (e.g., we want our Pivot Table report to be placed in a new sheet), so we can now go ahead and just press OK on this screen. Our Pivot Table is ready to go! Notice that Excel has created a new sheet; there is now a Pivot Table graphic on the left-hand side of the screen; and a PivotTable Field List dialogue that has appeared on the righ...
Read more