ニュース

You use Microsoft Excel 's built-in function to freeze specific rows and columns (often row or column headers), so when you’re scrolling through, these cells remain stationary on the page.
You can Cut or Copy Paste Columns and Rows in Excel spreadsheet - and keep the formulas and formatting using this step-by-step guide.
If you want to hide and unhide columns and rows in Microsoft Excel, then know it is easier than you might have thought. We explain how.
Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.
How to Hide Columns and Rows in Excel Hiding rows and columns in your Excel spreadsheet is straightforward, as expected. To do this, select the column or row you want to hide. Then, right-click on ...
How to Have Excel Freeze Row and Column Data It's often useful to freeze header rows or columns in Excel while navigating through a spreadsheet.
The typical unhiding techniques don't work everywhere in Excel. Learn an easy to remember method for unhiding row 1 and column A.
How to insert rows in between other rows in Excel If you want to insert a blank row between every other row, you're going to need what's known as a helper column.
Knowing how to alphabetize in Excel can be a real time-saver. Here, we look at how to alphabetize columns (and even rows) in an Excel spreadsheet.
How to Sort Multiple Rows and Columns in Excel. With Microsoft Excel's powerful sorting capabilities, you can enter unsorted data and let the software sort your data numerically, alphabetically or ...