Savvy’s Tips & Tricks: May 2022

success on the computer

Tips include: Excel, double-click to fill range; iOS 15 – bring back old Safari; PowerPoint – Master the slide master; and Windows Background Scrolling.

Excel: Double-Click to Fill Range

By now, most of us are familiar with the Fill Handle in Excel.  By dragging the fill handle in the lower-right corner of a cell or series of cells, the cell’s contents or an identified pattern is automatically filled as you drag.

Select and drag the fill handle until you have reached the end of the series or range of data.

Click here to read the full tip.

iPhone iOS15: Bring the old Safari back 

Some of us just don’t like change! In iOS 15, a new Safari was released with the Search Bar and Tab Switcher at the bottom. It is designed to let you easily swipe between tabs. However, if you want the old layout back – with the URL bar at the top  (like me!) – you can switch back.  

There are two ways to do it. Either go to Settings > Safari and scroll down until you see the two tab icons. Select “Single tab.” When you relaunch Safari, it will now display the bar at the top. 

The other quicker way to switch is opening Safari itself, open any webpage and tap the “AA” icon in the search bar. On the pop-up menu, tap the option that says, “Show Top Address Bar.” You are back to familiar territory.

PowerPoint: Mastering the Slide Master

Many of us are given a PowerPoint file to edit and have trouble deleting or changing elements on a given slide. This is often because the Slide Master has been used to present specific text, images or other items on every slide of a particular Layout. What does this mean?

Understanding the Terminology

1 – Slide Masters are the top slide in a hierarchy that stores information about the theme and slide layouts of a presenta­tion. Every presentation contains at least one slide master. The key benefit to modifying and using slide masters is that you can make universal style changes to every slide in your presentation, including ones added later to the presentation.

2 – Slide Layouts are the various types of slides that can be inserted. A new, blank presentation offers some standard layouts, including Title and Content, Two Content and a Blank slide.

Click here to read the full tip.

Excel: Double-Click to Fill Range

By now, most of us are familiar with the Fill Handle in Excel.  By dragging the fill handle in the lower-right corner of a cell or series of cells, the cell’s contents or an identified pattern is automatically filled as you drag.

Select and drag the fill handle until you have reached the end of the series or range of data.

Click here to read the full tip.

Windows 10 – Background Scrolling 

for Inactive Windows

If you moved to Windows 10 without a lot of fanfare, you may not be aware of a new feature. With more and more of us using dual monitors, we have lots of windows open at the same time. Being able to quickly glance through content without needing to “select it” can be a real timesaver.

Background Scrolling – What is It?

In previous versions of Windows, if you wanted to scroll through an open window that was not the active one, you had to first click into that window to select it. Consider the situation when you’re working on a Word document and want to be able to view a large Excel spreadsheet to view relevant data. By having both windows open, you can maintain the focus on the Word document and easily scroll through the spreadsheet. 

Simply hover over an open window (don’t click!) and use the mouse wheel to scroll up or down. As long as you don’t click, the focus will remain on your original window – in this case, the Word document.

Background Scrolling – How to Enable/Disable It… click here for the tip!

To receive our bi-monthly tips, sign up for our newsletter!

Facebook
Twitter
LinkedIn
Pinterest

Leave a Reply