Skip to main content

TIP - 54 : Data entry - to fill data always towards right - Advanced


Data entry - Move data always towards right – Advanced

Always you see that when we press enter in excel, it always goes down.

Can we change it? Yes
then the question is How? See below

Step 1: Please click on File menu, then click on Options

Step 2: From the dialogue box “Excel Options”, go to Advanced section then select the option we required from “Direction” drop down under Editing options.

We have all four options – Down, up, left and Right…
Now go ahead and choose…

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