Skip to main content

TIP - 35 : Using of Insert cut Cells


Using of Insert cut Cells

Insert cut cells used as one step shortcut to cut and paste data at time rather than copying the data once and inserting a new row or column again pasting the data.

Step 1: Select a cell or range of cells, then click on Cut from home tab or use keyboard short cut (Ctrl + X)

Step 2: Please right click on the cell where you want to replace the data, then click on “Insert Cut cells”

Now data will be moved.

Comments

Post a Comment

Popular posts from this blog

Report Publishing via Pivot Table in different sheets

Report Publishing via Pivot Table in different sheets This feature is mostly helpful to publish the data in sheet wise Step 1: Create pivot table with Report filter , go to analysis tab or Options tab from "PivotTable options" Step 2: Click on options drop down Step 3: Then click on  “Show report filter pages” Now we can see the new excel sheet tabs names along with data, published based on the report filtered data.
Post a Comment
Read more