cara membuat program akuntansi dengan excel

You can release a row by returning to the Freeze Panes menu.

Once you freeze a row, you can return to the Freeze Panes menu in the ribbon and choose Dave Johnson/Business Insider How to unfreeze a row In the ribbon, click 'Freeze Panes' and then click 'Freeze Panes.' Select the row under the one you want to freeze before selecting Freeze Panes. Select the row below the set of rows you want to freeze.ģ. When you use this option, you're actually freezing all the rows from the top down to the row you want to freeze - you can't freeze a random row in the middle ofĪ spreadsheet without locking everything above it at the same time.ġ. Now, when you scroll through the spreadsheet, the top row that was visible will remain fixed while the rest of the spreadsheet scrolls under it. In the ribbon, click 'Freeze Panes' and then click 'Freeze Top Row.' Click 'Freeze Top Row' to lock Scroll your spreadsheet until the row you want to lock in place is the first row visible under the row of letters.ģ. Keep in mind that this doesn't have to literally be the top row in your spreadsheet - this command lets you freeze the first visible row.ġ. $149.99 at Best Buy) How to freeze the top row in Excel $299.99 at Best Buy) Microsoft Office (From $1,299.99 at Best Buy) Lenovo IdeaPad 130 (From Check out the products mentioned in this article: MacBook Pro (From

There are two ways to do this: You can freeze the first visible row on your spreadsheet, or you can freeze a set of rows. How to Have Excel Freeze Row and Column DataĪn easy way to do that is to freeze a row (or column), so it stays in a fixed location while the rest of the spreadsheet scrolls up and down (or side to side).How to change the date format in Microsoft Excel to make the program write dates in a certain way.How to set a print area in Microsoft Excel to print a specific section of your spreadsheet.How to copy a formula in Microsoft Excel using a Mac or PC.

How to edit a drop-down list in Excel, depending on how you created.

How to combine two columns in Microsoft Excel without losing data.

Related coverage from How To Do Everything: Tech:.

Check out the products mentioned in this article:.

Cara membuat program akuntansi dengan excel