In a worksheet that contains data, we need to first decide what the row is and column that we need to hide accordingly, we can hide those rows and columns.
#SHORTCUT FOR HIDING ROWS IN EXCEL 365 MAC HOW TO#
read more, so we can hide these two things only apart from hiding worksheets in the end, we will also show you how to hide worksheets as well. The area of excel worksheet is divided into rows and columns and at any point in time, if we want to refer a particular location of this area, we need to refer a cell. Rows and columns make the software that is called excel. Hiding Rows and Columns in ExcelĮxcel has rows and columns Excel Has Rows And Columns A cell is the intersection of rows and columns. In this article, we will show you how to hide rows and columns in excel, using the shortcut keys to work efficiently.
However, in certain cases, we cannot group rows or columns rather, we need to hide those rows and columns, so this task is often regular for regular excel users, so maintaining the efficient way of doing this is very important.
When the data is large, or the summary table includes drill down summary, we choose the option of grouping the columns and rows, so that if we required, we can expand or collapse things to dig deep.
0 kommentar(er)
