PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
CONTENTS
HOW TO CREATE AND ARRANGE WINDOWS IN EXCEL?
INTRODUCTION
Windows option is given in Excel for a particular case when the sheet has many columns which are not visible in a single screen.
In real world cases, the sheets oftenly get so large that many of the dependent formulas are not visible at the same time and we have to scroll the sheet left and right to check the result.
Window option helps us with this case and gives us the option of opening different parts of our work at the same time in different windows.
BUTTON LOCATION FOR CREATING AND ARRANGING WINDOWS IN EXCEL
STEPS TO CREATE AND ARRANGE WINDOW IN EXCEL
SPLIT: Split the window into multiple parts at the location of the selected cell. It helps in simultaneously see the different parts of the same window.
HIDE: Hide the window. Unhide by clicking unhide button.
SAVE WORKSPACE: Save the workspace (All splits and windows) into a file with extension as xlw.
SWITCH WINDOWS: Switch between the open windows. The windows which we have created.
ANIMATED EXAMPLE TO CREATE AND ARRANGE WINDOWS
OTHER WAYS TO REACH THIS ARTICLE
WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL
YOU MAY LIKE
- HOW TO TROUBLESHOOT A FORMULA IN EXCEL?
- USE OF FONTS, FONT SIZE, INDENTATION, TEXT TO THE RIGHT, TEXT TO THE LEFT, TEXT IN THE MIDDLE ETC.
- how to insert table in excel?
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.