Rolanas argegamp

/en/excel/basic-tips-for-working-with-data/content/

Whenever you're working with a lot of data, it can be difficult to compare information in your workbook. Fortunately, Excel includes several tools that make it easier to view content from different parts of your workbook at the same time, including the ability to freeze panes and split your worksheet.

Optional: Download our practice workbook.

Watch the video below to learn more about freezing panes in Excel.

You may want to see certain rows or columns all the time in your worksheet, especially header cells. By freezing rows or columns in place, you'll be able to scroll through your content while continuing to view the frozen cells.

If you only need to freeze the top row (row 1) or first column (column A) in the worksheet, you can simply select Freeze Top Row or Freeze First Column from the drop-down menu.

If you want to select a different view option, you may first need to reset the spreadsheet by unfreezing panes. To unfreeze rows or columns, click the Freeze Panes command, then select Unfreeze Panes from the drop-down menu.

If your workbook contains a lot of content, it can sometimes be difficult to compare different sections. Excel includes additional options to make your workbooks easier to view and compare. For example, you can choose to open a new window for your workbook or split a worksheet into separate panes.

Excel allows you to open multiple windows for a single workbook at the same time. In our example, we'll use this feature to compare two different worksheets from the same workbook.

If you have several windows open at the same time, you can use the Arrange All command to rearrange them quickly.

Sometimes you may want to compare different sections of the same workbook without creating a new window. The Split command allows you to divide the worksheet into multiple panes that scroll separately.

To remove the split, click the Split command again.

Within our example file, there is A LOT of sales data. For this challenge, we want to be able to compare data for different years side by side. To do this:

Zucchini stir fry made under 15 mins. This stir fried zucchini tastes delicious and goes well as a side with any meal. It can also be used as a filling in wraps, kathi rolls and sandwiches. I make stir fry dishes with most veggies as they are super quick to make. This one is often on our menu.

It is minimally spiced and flavored so it is kids’ friendly too. Here are my tips and substitutes for the recipe.

Zucchini: Choose firm zucchini and avoid soft ones. Soft zucchini have soft pulp inside which is inedible.

Onions: Onion can be substituted with spring onions. You can also skip them completely.

Vegetables: I have used bell peppers here as we like their flavor with zucchini. You may skip them or add any other veggies like mushrooms, carrots or pumpkin. If using pumpkin stir fry until slightly tender, then add the zucchini.

Flavoring: Zucchini stir fried on a high flame with some oil, garlic, bell peppers and black pepper smells great. It doesn’t need any other flavoring. But this time I also used soya sauce & apple cider vinegar. You may skip them completely if you do not prefer.

For spice & heat: I have used black pepper. You can also add chopped green chili or dried red chili for extra heat.

A wok or a cast iron skillet works good for this stir fry.

Similar stir fry recipesCabbage stir frySweet Potato stir fryBroccoli potato stir fryIndian style Tofu stir fryZucchini curry

Preparation

Rinse all the veggies under running water. Fine chop ginger and garlic. Slice onions & bell peppers thin. You can chop zucchini however you like. I prefer to chop them to 1/4 inch thick. If you slice them too thin they will overcook and turn too soft in no time.

2. Then add the sliced onions and fry until transparent.

3. Add bell peppers and fry for 30 seconds.

4. Add zucchini and stir fry just for 2 to 3 mins. Do not over cook them, they should be half done and crunchy.

5. Add soya sauce, vinegar and black pepper. Stir fry just for 30 seconds until you begin to smell it good. Turn off the stove and add salt. Mix it. You can adjust salt and black pepper to your taste.

6. Sprinkle toasted sesame seeds or roasted and crushed peanuts.

Serve stir fried zucchini as a side or wrap it in your rolls or sandwiches.

Related Recipes

Save on popular hotels near TD Garden, Boston: Browse Expedia's selection of 1936 hotels and places to stay closest to TD Garden