Skip to main content

Posts

Showing posts from August, 2017

How To Go To Last Row/Column With Data In MS Excel | How To Select entire Row/Column | dptutorials

In Excel, from any particular cell if you would like to move to last row, we generally press Ctrl + Down arrow and to move to last column, we press Ctrl + Right arrow . Similarly for first row and first column, we press Ctrl + up arrow & Ctrl+ left arrow respectively. This is all we knew til now. But there’s a shortcut even for this?? Let’s see how it is now. Go to any cell and from here if you would like to move to the last row, simply double click the bottom edge of the cell. Similarly double click on right edge of the cell to move to last column. You can try with other two edges to move to the first row and first column.  Similarly to select the entire column, go to the first cell, hold shift and double click the bottom edge of the cell. You can do the same logic for selecting entire row as well. For Personalized detail learning, write to  dptutorials15@gmail.com If you found this video valuable, give it a like. If you know someone who needs...

How To Change The Shape Of Comment Boxes In Excel | Insert and Edit Comments in Excel | dptutorials

How To Change The Shape Of Comment Boxes In Excel | Insert and Edit Comments in Excel. ·          When you go to any cell in Excel and upon right click, you will be seeing the option called “ Insert Comment ”, by clicking this you can insert your comment for that particular cell. ·          Once you are done with the inserting of comment into the cell. Now, whenever you place the cursor on the cell, you could notice that the comment is becoming visible. ·          If you would like to reshape this comment box, right click on the cell and choose edit comment, then hold any corner of the box and drag to make it wider, taller to adjust the content. ·          But, sometimes you would like to even have different shapes altogether. So, in order to do this, we need to activate a feature that is not availa...