• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Digital Answers

How to tech tutorials in simple words

  • Home
  • About Us
  • Disclaimer
  • Privacy Policy

Admin

How to Verify Email Addresses in Google Sheets: A Step-by-Step Guide

December 10, 2022 by Admin Leave a Comment

In Google Spreadsheet you can check whether the value entered is a proper email address by creating a data validation rule. This rule does a simple verification and checks for the @ symbol in the entered value. Let us say you have a column in your spreadsheet that needs to accept only email addresses, then you can do the following to add the validation.

Select the Column values, click the Data menu and select Validation from the menu list.

In the Data Validation window, select Text, Contains for the Criteria drop down and specify the value as @

And if you want to display a message to the user then type the message in Help text some thing like “Enter proper email address example aaaa@xxx.xxx”. Click on the Save button to save the changes.

Now when you enter a value in the email address column without the @ symbol then it would display the message as shown below.

Filed Under: Excel, Technical Tagged With: Contains, Data Validation, email address, Google Spreadsheet, Validate

How to increase number of worksheets Excel

March 18, 2016 by Admin 1 Comment

Microsoft Excel by default contains 3 worksheets while creating a new Workbook. For creating a new workbook you can specify the number of Worksheet that a Workbook needs to contain. This can be modified using Excel Options. Listed below are steps for increasing number of Worksheets for a new Workbook in Excel 2013, Excel 2010 and Excel 2007

In Excel 2013 and Excel 2010 –> Click on File menu and then Options.

increase sheets in Workbook in Excel 2013

In Excel 2007 –> Click on Excel Options and then Popular menu.

Excel Options in Excel 2007

Increase worksheets for new workbook in Excel 2007

Under When creating new workbooks section there is include this many sheets fields. This can be used for increasing the number worksheets while creating a new workbook. The minimum value is 1 and the maximum is 255. Check out the below video demo to increase worksheets size in Excel 2013

Also See: How to move or copy worksheets in Excel 2013

Filed Under: Excel, Excel 2007, Excel 2010, Excel 2013, Office 2007, Office 2010, Office 2013 Tagged With: Decrease sheets, increase sheets, Workbook, Worksheets Size

A trick to flip a column upside down in Excel

February 17, 2016 by Admin Leave a Comment

Excel users can sort a column using the Sort feature available as part of Sort & Filter menu. But what if you want to flip a column upside down. Let us see this with an example column having some text values as shown below.

We will not be able to apply sort feature directly on this column to flip the data instead we can add a dummy column and use that for sorting the text values.

Step 1: Insert a new column before the existing column.
Step 2: Now use Auto Fill feature to fill the temp with numbers as shown below

Step 3: Now you can use the Sort feature on column1 and make sure to sort by descending order. Also include the column2 in Sort sleection list.

Step 4: Once the columns are sorted, delete the temp column with numbers.

Filed Under: Excel, Excel 2007, Excel 2010, Excel 2013, MS Office

Prevent users from adding new worksheet in Excel

January 25, 2016 by Admin 2 Comments

Excel 2016, 2013 and 2010 provides an option to prevent users from adding new worksheet to existing Workbook structure. So if you are the owner of Excel file and you do not want to allow other users to add any new worksheet, rename or move worksheet then you can use Protect Workbook Structure option to change the permission. You can access Protect Workbook Structure from the Info menu.

image

Click the File menu and then navigate to Info menu and click the drop down arrow under Protect Workbook option. From the list of available option select Protect Workbook Structure. This would display the following Protect Structure and Windows. Mark the check box with label as Structure. If you want to password protect it then enter a password in the Password field. Click Ok button to save and confirm the changes.

image

Filed Under: Excel, Excel 2010, Excel 2013, Excel 2016, MS Office Tagged With: add sheet, Excel 2010, Office 2010, prevent, Protect Workbook Structure, Worksheet

How to include original message in Outlook

December 8, 2015 by Admin Leave a Comment

Microsoft Outlook users can include the original message while forwarding or replying to an email. The users can choose any one of the following options for original message

  • Do not include original message
  • Attach original message
  • Include original message text
  • Include and indent original message text
  • Prefix each line of the original message 

Listed below are the steps to access the message handling option in Outlook 2013, Outlook 2010 and Outlook 2007

Include original message in Outlook 2016, Outlook 2013 and Outlook 2010
Click File menu, select Options from the list.

Outlook Options

In the Outlook Options window, click Mail tab then scroll down Replies and and forwards section.

Replies and forwards option in Outlook 2013, Outlook 2010

Use the option “When replying to a message” and “When forward a message” to specify the option for original message.

Include Original Message in Outlook 2013, Outlook 2010

Include original message in Outlook 2007

Tools -> Options -> Email Options -> On replies and forwards section

Email Options in Outlook 2007Attach Original message in Outlook 2007

Using the drop down available under when replying to a message and When forwarding a message, you can choose any of the following values from drop down.

Include Original message text in Outlook

Also See: Close original message on reply or forward in Microsoft Outlook

Filed Under: MS Office, Outlook 2007, Outlook 2010, Outlook 2013, Outlook 2016 Tagged With: Attach Original Message, Email Options, Include Original message, Replies and Forwards

Disable permanently delete items warning message in Outlook

November 22, 2015 by Admin 18 Comments

Outlook displays a warning message when deleting outlook emails. It displays a dialog box with message “Are you sure that you want permanently delete the selected items” as shown below

Are you sure that you want to permanently delee the selected items in Outlook

This is very useful warning option for the users before deleting the mail items permanently. But If you do not want to see the permanently deleted warning message then turn off or disable this warning message.

Disable warning message in Outlook 2016, Outlook 2013 and Outlook 2010

Click on the File menu –> Options and navigate to Advanced tab.

Prompt for confirmation before permanently deleting items in Outlook 2013 and Outlook 2010

Scroll down to Other section and clear the checkbox with label as Prompt for confirmation before permanently deleting items. Click OK to save the changes.

 

Turn off permanently delete warning message in Outlook 2007

This warning message can be disabled in Outlook 2007 by using Tools –> Options.

Go to Tools –> Options and select Other tab.

Outlook 2007 Advanced Optons

Click on the Advanced Options button. The following Advanced Options window would be displayed.

Outlook 2007 Warn before permanenly deleting items

Uncheck the “Warn before permanently deleting items” to disable the warning message.

Also See: How to turn off send without attachments warning message in Outlook

Filed Under: MS Office, Outlook 2007, Outlook 2010, Outlook 2013, Outlook 2016 Tagged With: delete mail items, Deleted Items, Disable, Outlook, Turn Off, Warning Message

  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Interim pages omitted …
  • Go to page 9
  • Go to Next Page »

Primary Sidebar

Recent Posts

  • A Guide to Using the MAX and MIN Functions in Excel
  • How to display fractions in Excel
  • How to Separate a Person’s First and Last Name in Excel
  • How to Verify Email Addresses in Google Sheets: A Step-by-Step Guide
  • How to increase number of worksheets Excel

blogmines.com Copyright © 2023