Trending December 2023 # How To Use Excel Autorecover And Autobackup Features # Suggested January 2024 # Top 12 Popular

You are reading the article How To Use Excel Autorecover And Autobackup Features updated in December 2023 on the website Cancandonuts.com. We hope that the information we have shared is helpful to you. If you find the content interesting and meaningful, please share it with your friends and continue to follow and support us for the latest updates. Suggested January 2024 How To Use Excel Autorecover And Autobackup Features

It’s always a terrible tragedy when someone loses something important they were working on because they didn’t save their document properly. This happens more often than you would think to Excel and Word users!

Luckily, Microsoft has added a lot of features in the last couple of versions that help reduce the chances of losing data due to crashes, power outages, accidental deletions, etc. One feature is called AutoRecover and the second, less-commonly known feature, is called AutoBackup.

Table of Contents

In this article, I’ll talk about how to configure both options so that your data is as safe as possible. I would also like to mention that the latest versions of Office allow you to save documents directly to OneDrive, which is a good option to consider because you’ll still be able to access your work even if your hard drive fails.

Excel AutoRecover

By default, AutoRecover information is saved every 10 minutes. In addition to the interval, Excel has to be idle for 30 seconds before the data will be saved. Also, the autosaved information is saved in the AutoRecover file location listed here. So how does it work? Basically, let’s say you have a worksheet like the one below and you have it saved.

In my case, I simulated an Excel crash by opening the task manager and killing the Excel process. After that, I reopened Excel and immediately saw an option called Show Recovered Files.

The major downside to this feature is that the AutoRecover data is stored on the same hard drive as your file, so if something happens to your hard drive, everything will be gone. You can change the location in the settings above to a separate hard drive or even to a network location, which I highly recommend.

Note that AutoRecover information is also deleted automatically by Excel in the following circumstances:

You save the file manually or by using File – Save As.

You close the file or quit Excel (whether you save the file or not)

You turn off AutoRecover completely or for just the workbook

So basically, whenever you save the file, it gets rid of the AutoRecover data. In addition, if you manually quit Excel and choose not to save the data, it will delete the AutoRecover data. Just keep that in mind when using this feature. If you are a heavy Excel user, I would suggest setting the AutoRecover interval to something like 2 or 3 minutes instead of 10.

AutoBackup

Another feature that not many people really know about it is AutoBackup. To use it, you have to first go and save your file to get to the Save dialog box. If you already have a saved Excel document, go to File and then Save As and choose a location. When you do this, it’ll bring up the Save As dialog.

Basically, the backup file is always one version behind the current version. So if you made a bunch of changes, saved your file and then wanted to go back to the version that didn’t have those changes, you could just open the backup file.

The file is saved in the same location as the original file and there doesn’t seem to be a way to change that. This feature doesn’t add a whole lot of safety to your document, but it’s good in certain circumstances.

You're reading How To Use Excel Autorecover And Autobackup Features

How To Use Calendar In Excel?

Calendar in Excel

Excel Calendar is a customized calendar in which we can create our calendar with the help of a template available. The main problem comes when we must decide what the first day of the year will be. For the Year 2023, we all know that the first day started on Wednesday. To decide the day of 1st Jan, use the DATE function to find the first date of the month and then subtract the 1st Weekday Date using the WEEKDAY function along with DATE.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Excel provides a variety of different templates which is already formatted and ready to use.

How to use the pre-built calendar in Excel?

To create a pre-built calendar in Excel, follow the below process:

You can download this Calendar Excel Template here – Calendar Excel Template

Go to the File tab.

It will open several options in the right side window. Refer to the below screenshot.

In this window, we have to enter what we are looking for in the search box.

Type Calendar in the box and press Enter key like the below screenshot.

It will display various types of calendar options, as shown below.

It has many options like monthly and yearly calendar formats.

Scroll the bar and choose the Photo calendar (Mon) option. Refer to the below screenshot.

It will open an Excel workbook having a month-wise date calendar.

 Here month-wise tab is available, as shown in the screenshot below.

It will look like the below screenshot.

We can format this calendar by changing pics as per our choice.

You can change the address and contact details in the box available on the right side. Refer to the below screenshot.

Like in the below screenshot, we have mentioned some notes date-wise.

You can customize the calendar using the format tab as per your requirement.

A calendar in Excel is very important in any company, and it uses for different purposes. Here we are taking an example where we will see a way to create a calendar in Excel for a team.

Use Custom Calendar sheet in Excel.

Let’s consider two employee data in a calendar in the Excel sheet. David & Ian are two employees in a team, as shown below:

Thus, we are creating a monthly Excel calendar for them. Let’s write the first date of the Jan 19 month in Cell B1. Now, in Cell C1, we will apply the formula =B1+1 for the next date, as shown in the screenshot below.

Hit the enter key and drag this formula in the next columns for the last day of the month. Here drag till the 31st Jan 19.

Copy the same dates in Row 2. Refer to the below screenshot.

It will open a drop-down list of items.

Choose the Custom option from the Category window and write “ddd” under the Type field for Weekdays. “ddd” refers to Mon, Tue, etc. Refer to the below screenshot.

It will convert the dates into weekdays in Row 1.

Again select the whole dates in Row 2 and write “dd” in the Type field under the Custom option. It will convert the dates into days, as shown in the below screenshot.

Select the columns from B to AF and move the cursor on the line between any two columns, and it will compress the cells as shown in the below screenshot.

And our calendar will look like below:

Now our Template is ready. Make a copy of this sheet and give the month name of the sheets, like Jan 2023, Feb 2023, etc. Put the name of this sheet as Template.

For Feb 2023 month, we need to change the date of months like below.

As we can see, the calendar template is ready with us, and now we can use this for scheduling team employee activities date and month-wise.

How to Print a customized Calendar in Excel?

In the above section, we learned how to create a calendar. We also can take the print of this. Follow below steps for printing a customized calendar:

Step 1 – Go to the Page Layout tab.

Step 4 – Choose 1 page under Width and Height boxes in the Scale to Fit, As shown in the screenshot below.

Now your customized calendar is ready to print on one page.

Things to Remember 

Using this Excel Calendar, you can easily keep track of daily, weekly, and monthly activities, schedules, etc.

You can keep track of your business growth by watching the progress on a fixed-date timeline.

You can keep real-time watch and visibility into the business’s status, resources, and performance.

Recommended Articles

This has been a guide to Calendar in Excel. Here we discuss how to use a pre-built calendar in Excel, a Custom calendar, and print the customized calendar along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

How To Use Makeup To Downplay Certain Features?

Makeup is a versatile technique that may both highlight and minimize particular traits. There are makeup techniques you can employ to do this if there are features of your appearance that you’d like to diminish or de-emphasize. These methods include colour correction, the thoughtful placement of shadows, and the use of foundation or concealer to draw attention away from problem areas. You can get a balanced and attractive appearance by being aware of your features and employing the appropriate approaches.

To Highlight Your Eyes

There are a few techniques to emphasize the size and shape of your eyes without going for a super-dramatic eye makeup look. No of the form of your eyes, lining the top lash line tightly with a black pencil or gel liner is a terrific method to add definition and make your eyes stand out. To make eyes appear bigger and brighter, dab a sparkly eyeshadow or highlighter in the inner corners, directly by the tear ducts. Focus mascara on the outer lashes for a broad, doe-eyed appearance.

To Play Down Your Nose

The ideal way to make your nose look smaller and thinner is with standard contouring techniques, but you don’t have to go overboard with the highlighting and shading. Draw a straight line along the bridge of the nose and blend it in with a highlighter or concealer that is slightly lighter than your skin tone. Also, you can darken the sides of the nose with a slightly darker powder.

To Make Your Lips Stand Out

The smallest amount of shimmery highlighter applied to your cupid’s bow, the small ‘V’ shape in the centre of your top lip, will do the trick to draw attention to your lips and make them appear bigger without adding colour or dramatic shading.

To Emphasize Your Cheekbones

Start with a matte contouring powder or cream to give your cheekbones a sharp, defined appearance—or to add some where there are none. You should delicately brush or mix the colour into the hollows of your cheeks after sucking in your cheeks to determine where the shadow should go. A highlighter should be applied just over the blush, slightly above the shadow, angled up toward your temple. This three-step technique gives depth without being forced.

Use Powder to Chisel Your Chin

Using shaping powder is a quick and simple approach to add extra definition to your jawline if it isn’t quite as defined as you’d want. Apply a light layer of a greyish-brown (not too orange) powder along the jawline, from the back of the ear to the tip of the chin. Do the same technique to the opposite side of your jaw. Make sure the powder is evenly distributed down your neck to avoid any visible lines or colour discrepancies. Your newly chiselled bone structure will look fantastic.

Overlining the Lips

Little is more in this case, yet even this minor change will dramatically alter how your lips seem. The secret is to line your lips completely with a matte, neutral-coloured lip liner before tracing just outside of them. Avoid going more than a few millimetres past your natural lip line because it appears too blatant (and a little scary). Instead of overlining the entire rim, you might deliberately choose certain parts, such as the bottom lip or cupid’s bow. Apply your preferred matte lipstick to both your lips and the overlined region once you’ve overlined. Your additional line will be hidden by a matte finish, as opposed to shiny lipstick that draws attention to it.

Smoothing Foundation

Many foundations have a propensity to caking, cracking, and flaking, which would probably highlight any wrinkles and flaws rather than hide them. One of the simplest ways to make your face look younger is to smooth the skin. It entails beginning with a primer that evens out the surface of your skin, just as a painter would spackle and prime walls before adding colour.

Use Strategic Eyeliner

Applying eyeliner in the appropriate style and colour is the ideal technique to noticeably change the form of your eyes, regardless of whether they are too big, too little, too downturned, or too something else. The lower lash line, which serves as a continuation of your eyes and makes them appear larger, can be lined in white to open up the eyes. Nothing works better for downturned eyes than a reverse cate-eye with black liner. Apply smoky eyeliner to the outer corners of hooded lids to give the appearance of lift.

Tips To Use Makeup to Downplay Certain Features

Here are some pointers on how to use makeup to hide specific features −

Employ a deeper foundation tone on the sides of the nose and a lighter shade on the bridge to give the appearance of a smaller nose when trying to hide a prominent one. On the nose, stay away from applying glittery or highlighting cosmetics.

Use a foundation or bronzer in a slightly deeper tone along the hairline and blend well to hide a big forehead. This will give the appearance that the forehead is smaller.

Apply a deeper blush or bronzer along the jawline and temples to give the face a more contoured appearance if your face is wide. On the sides of the face, stay away from using shimmery or highlighting products.

Put lip liner just outside of your natural lip line and fill in the gaps with lipstick or gloss in a colour that is similar to your natural lip colour to hide a small mouth. Your lips will appear bigger as a result.

Employ a light shade of eyeshadow on the lids and a deeper shade in the crease to add depth and minimize heavy eyelids. On the top lids, avoid using heavy eyeliner or mascara as this might make them appear much heavier.

Never forget that the purpose of makeup is to complement your natural features and give you confidence, not to alter or completely conceal them. These suggestions can help you get a more balanced and attractive appearance, but don’t be afraid to experiment to find what suits you best!

Conclusion

It can be helpful to know how to use makeup to hide specific flaws in your face. There are methods you can employ to obtain your desired look, whether you want to reduce the appearance of a high forehead, narrow down a wide nose, or create a more balanced face structure.

The opposite hues on the colour wheel can be used to neutralize unwelcome skin tones, which is one of these strategies. Another is the careful employment of shadows to provide the impression of depth and structure. A more balanced appearance can be achieved by concealing or minimizing certain regions using foundation.

It’s crucial to remember that makeup should not be used to entirely conceal or disguise your features; rather, it should be utilized to give you a more symmetrical and harmonious appearance. As always, maintaining a healthy and radiant complexion requires using high-quality skin care products and properly removing your makeup. You may perfect the technique of wearing makeup to hide specific flaws and attain your ideal look with practice and experimentation.

How To Use Vba Trim Function To Remove Spaces In Excel?

Excel VBA Trim Function

Excel VBA Trim Function is used for removing the extra spaces from any cell or text and gives us the output which has a standard in terms of required spaces. VBA Trim function works exactly as the Excel Trim function and Trim function also removes the extra spaces in 3 ways;

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

Spaces from the starting of the text.

Spaces from the end of the text.

Spaces from the middle of the text if more than 1 extra space is seen.

This mostly happens when we download data from some server, data warehouse or while incorrectly inserting the extra spaces manually. Even though we can easily see the spaces at the middle of the text, but spaces at the beginning and end of text cannot be seen easily until and unless we go to edit mode of that specific cell. This can be done by VBA Marco.

How to Use Excel VBA Trim Function?

We will discuss how to use VBA Trim Function by using some examples.

You can download this VBA Trim Function Excel Template here – VBA Trim Function Excel Template

VBA Trim Function – Example #1

Here we have 3 cells in the below screenshot.

And each cell has some spaces associated with them. Cell A1 has spaces at the end.

Cell A2 has spaces at the beginning of the text.

And cell A3 has space in between the text which is highlighted in the below screenshot.

This will take us to Visual Basic coding window. Now go to the Insert menu from VBA window and select Module as shown below.

This will create a new Module where we will write a code for trimming. Below are the steps for creating and writing trimming code:

First, choose a variable and define a range. Here we have selected the variable “A”. This variable can be anything.

As our data set has already some text or object then we need to set the range for it. And for that, we will use “Selection”. It will automatically select the data in the present sheet.

Code:

Sub

Trim_Data()

Dim

A

As

Range

Set

A = Selection

End Sub

For selecting each filled cell of the sheet “For Each” is the function And Value function is used for selecting the value with Trim(Cell) selection.

Code:

Sub

Trim_Data()

Dim

A

As

Range

Set

A = Selection

For Each

cell

In

A cell.Value = WorksheetFunction.Trim(cell)

Next

End Sub

By this, we complete the coding work for creating macro through VBA Trim. Now let’s apply the created code into some tab. For this go to Insert Menu and under Illustrations select Shapes.

From that Shapes option, create any shape using shape formats and styles.

VBA Trim Function – Example #2

VBA Coding shown above can be written in one more way. In the above example, we only trimmed the selected data. In this we will insert the function in the message box as well it will show once the data is trimmed.

Once we do that, we will get the Visual Basic window. Now open a fresh Module and start coding on that page.

Now consider the same code which we have written in example-1. But here for printing a message box with the text we will insert some text.

Sub

Trim_Data2()

  Dim

A

As

Range

Set

A = Selection

For Each

cell

In

A cell.Value = WorksheetFunction.Trim(cell)

Dim

B

As

 

String

B = Trim("Trimming Done") MsgBox B

Next

End Sub

Once we are done with writing the code, close the Visual Basic windows.

After that, we will get the button created on the screen.

As we can see above, here our data got trimmed and we can see the message as well of “Trimming Done”.

Pros of Excel VBA Trim Function

We can trim huge sets of data in one shot without checking the number of extra spaces the cells have.

Coding of trimming function is also quite small.

There are very less or no chances that any extra space will get spared.

Things To Remember

Always save the file as Macro-Enabled Worksheet. By doing this, we can use assigned macro multiple time.

Compile the code before assigning it to any button.

There are 2 different ways are shown for creating a button and both can be used as per individuals need or wish.

Consider writing VBA Code as shown in example-2 which will give the message as well.

Recommended Articles

This has been a guide to Excel VBA Trim. Here we discussed how to use VBA Trim Function to remove spaces in Excel along with some practical examples and downloadable excel template. You can also go through our other suggested articles–

Oneplus Pay Features And How To Setup

Online payments have gained popularity all over the world, the reason being that online payments are safer and cheaper. It is evident that the world has become a global village, and hence one can send money to any part of the world via online payments. Some online payment options include Google Pay, PayPal, Skrill, Visa, Mastercards, but to mention a few.

Another payment option is OnePlus Pay, which is currently supported by the  OnePlus 7T series. However, other phone models will be given access to these payment options at a later date which is not specified. We look at OnePlus Pay features and how to set it up.

What is OnePlus Pay?

OnePlus Pay is an online payment method that is new in the market but gaining popularity at a very high rate. Android phone users use Google Pay to facilitate ease of payment. The Apple company was not left behind since it also came up with Apple Pay. OnePlus Pay is a mobile payment service that is compatible with OnePlus mobile phones.

This credible payment method is expected to be released in April 2023. China will be the first country to benefit from this payment option. Currently, the payment option has gained U.S. market trust. The OnePlus Pay method will be extended to countries like India, where there are a lot of OnePlus mobile users.

At the initial stages, only three Chinese bank cards will be supported, which include: Guangfa, SPDB and the Minsheng banks. As time goes, more bank cards will be supported. It is notable that Google Pay also started with a low number of banks but added more as time went by.

OnePlus Pay Features

The OnePlus Pay payment method has fantastic features that make it outstanding. Some of these features include:

It has a user-friendly interface making the interaction between the user and the application easy.

It is faster- The OnePlus Pay method is a swift payment option compared to other payment options which take Days to process your payments.

OnePlus Pay supports NFC (Near Field Communications), which allows convenient payment of various goods and services.

This payment option is much safer compared to other options that can easily be hacked into.

Once fully launched, this payment option will be very reliable and convenient among its users.

It is supporting a variety of applications that require online payment.

A user guide to facilitate ease of the application.

How To Setup OnePlus Pay on OnePlus 7T series

As mentioned earlier, this payment option is only compatible with the OnePlus 7T series at the moment. We will look at how to set-up the payment option on your mobile device.

Proceed to include your desired bank card from the bank options given

Set-up the card to make it active.

Select your desired transaction authorization method. This may be a PIN, face lock or even a fingerprint lock.

Mostly, the OnePlus Pay supports the face lock or fingerprint lock authorization methods since it is much safer compared to the PIN authorization mode.

It adds up to use OnePlus Pay

The user gets to enjoy a lot of features provided by the OnePlus Pay method. It is a very safe way of transacting payments, and it is a quicker method compared to previous payment options. One can link his/her desired bank card to the OnePlus Pay option to facilitate ease of transactions.

You get to enjoy a user-friendly interface that is easy to use with the OnePlus Pay. Try out the OnePlus Pay, and you will get a fantastic online payment experience.

How To Freeze Rows In Excel?

Freeze Rows in Excel

In Excel, we have a function for freezing the rows as well. With the help of Freeze Row, we can fix the pane or row we select to go beyond the certain limit worksheet. Freeze Row can be accessed from the View menu tab’stab’s Window section from the drop-down list of Freeze Panes. First, to freeze the column, select the column we want to freeze, put the cursor anywhere in that column, and then select the Freeze Column option from the list. We will be able to see the selected column is now frozen.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Here we have 3 options. Freeze Panes, Freeze Top Row, and Freeze Top Column. I will show you examples of Freeze Rows in this article.

How to Freeze Rows in Excel?

We use Freeze Panes in Excel to keep an area or heading of a worksheet visible while scrolling to another part of a worksheet. This is very useful and convenient when working on a large table. So we select Freeze Panes from the View tab and keyboard shortcuts to lock that area.

You can download this Freeze Rows Excel Template here – Freeze Rows Excel Template

Let’s understand how to Freeze Panes in Excel with some examples.

Freeze or Lock Top Row – Example #1

Usually, our header is located in each column, i.e., horizontally. When scrolling down, we need to lock or freeze our first or top row, enabling us to see the first or top row at any given time.

Now look at the below image of sales data in the sheet.

It isn’t easy to see all the headers when scrolling down. So, in Excel, we have an option called Freeze Top Row, which holds onto the top row when scrolling down and helps us see the heading all the time.

Let’s look at the below steps to understand the method.

Step 1: Select the worksheet where you want to freeze your top row.

Step 3: Ok, done. It is as easy as you eat pizza. You have frozen your top row to see the top row while scrolling down.

Even though I am in the 281st row, I can still see my headers.

Freeze or Lock Multiple Rows – Example #2

We have seen how to freeze the top row in the Excel worksheet. I am sure you found it a walk-in-the-park process; you did not have to do anything special to freeze your top row. But we can freeze multiple rows as well. So here, you need to apply simple logic to freeze multiple rows in Excel.

Step 1: Identify how many rows you need to freeze in the Excel worksheet. For an example, take the same data from the above example.

Place a cursor on the A8 cell. This means I want to see all the rows above the 8th row.

Step 2: Remember we are not only freezing the top row, but we are freezing multiple rows at a time. Do not press ALT + W + F + R in a hurry; hold on momentarily.

After selecting cell A8 under freeze panes, again select the option Freeze Panes under that.

Now we can see a tiny grey straight line below the 7th row. This means the above rows are locked or frozen.

You can keep seeing all 7 rows while scrolling down.

Things to Remember

We can freeze the middle row of the Excel worksheet as your top row.

Make sure the filter is removed while freezing multiple rows at a time.

If you place a cursor in the unknown cell and freeze multiple rows, then you may go wrong in freezing. Make sure you have selected the right cell to freeze.

Recommended Articles

This has been a guide to Freeze Rows in Excel. Here we discussed How to Freeze Rows in Excel and different methods and shortcuts to Freeze Rows in Excel, along with practical examples and a downloadable Excel template. You can also go through our other suggested articles to learn more –

Update the detailed information about How To Use Excel Autorecover And Autobackup Features on the Cancandonuts.com website. We hope the article's content will meet your needs, and we will regularly update the information to provide you with the fastest and most accurate information. Have a great day!