Tux Tech – Page 3 – Leading IT Tutorials Platform

Using Find and Replace in MS Excel 2016

While working loads of data in MS Excel it can become very difficult as well as time taking to locate the specific information. You can search for the workbooks by using the Find feature which will let you change the content by using the Replace feature. You can also learn about Cell Basics in MS Excel 2016.

Finding the Content:

1^st of all from the Home tab you need to click the Find and Select command and after that select Find from the drop-down menu.
Now you will notice the Find and Replace dialog box will appear,
Now enter the content which you want to find.
Now click on Find Next and if content is found then the cel containing that content will be selected.
Click Find Next in order to find further instances or click Find All in order to see every instance of the search term.
When you are done click on Close in order to exit the Find and Replace dialog box.
Find command can also be accessed by pressing Ctrl+F from your keyboard.

Replacing the Cell Content:

There are some scenarios where you will find out that you have made repeatitive mistakes throughout the workbook like misspelling anyone’s name. You may also have to exchange a particular word or phrase for another one. IN such situations you can use Find and Replace feature in order to make quick revisions.

1^st of all you are required to click on Find and Select command from the Home tab and select Replace from the drop-down menu.
Now you will see the Find and Replace will appear.
Type the text which you need to find in the Find What field.
IN the next step you are required to type in the text which you need to replace it with in the Replace With: field and after that click Find What.
Now if the content is found the cell containing the content will be selected.
Now you need to review the text in order to make sure you want to replace it.
Now if you need to replace it select one of the replace option. Selecting Replace will replace the individual instances and Replace All will replace each instance of the text throughout the workbook,
Now you will notice that a dialog box will appear confirming the number of replacements made. Click OK in order to continue.
The selected cell content will be replaced.
Once you are finished you are required to click Close in order to exit the Find and Replace dialog box.

With these simple steps you will be able to find and replace particular word or phrase in your worksheet.

Cell Basics in MS Excel 2016

While working with MS Excel you will have to enter the information into the cells which are actually the basic building blocks of the worksheet. As this is the basic building block so you need to learn the basics of the cells as well as cell contents in order to calculate, analyze and organize the data in MS Excel. All the worksheets are made up of loads of rectangles which are known as cells. A cell is actually an intersection of rows and a column. The columns are assigned alphabetical letters like A,B and C etc. On the other hand cell is identified by numbers like 1,2 and 3 etc. Each cell has got a unique cell address which is based on it’s column and row. In this tutorial you will learn some of the basics of the cell. You can also learn about Exploring Paint 3D in Windows 10.

Selecting a Cell:

In order to select a cell you need to follow these simple steps.

1^st of all you are required to click a cell and then select it.
Once you click on the cell a border will appear around the selected cell and you will see that the column heading as well as row heading will be highlighted.

Selecting the Cell Range:

In order to select the cell range you need to follow these simple steps.

1^st of all click and drag the mouse until all of the adjoining cells you need to select are highlighted.
Now release the mouse to select the desired cell range. The cell will remain selected till you click another cell in the worksheet.

Inserting the Cell Content:

1^st of all you are required to click a cell in order to select it.
Now you need to type something into the selected cell and the press Enter from your keyboard. The content will appear in the cell and the formula bar. You can also input as well as edit the content of the cell in the formula bar.

Deleting the Cell Content:

1^st of all you need to select the cells with content which you need to delete.
Now you need to select the Clear command on the Home tab and after that click Clear Contents.
The contents of the cells will be deleted.

Deleting the Cells:

1^st of all you are required to select the cell which you need to delete.
Now select the Delete command from the Home tab on the Ribbon.
The cells below will shift up and will fill in the gaps.

Copy and Paste Cell Content:

1^st of all select the cells which you need to copy.
Click the copy command located on the Home tab or you can also opt to press Ctrl+C on your keyboard.
Now select the cell where you need to paste the content.
Click the paste command on the Home tab or you can also opt for pressing Ctrl+V from your keyboard.
The content will be pasted into the selected cells.

With these steps you will be able to paste the cell contents from one cell to another.

Exploring Paint 3D in Windows 10

Paint 3D is a very handy and intuitive program and in order to master this program you need acquire the necessary knowledge so that you can move on to the more complex projects.Once you will master all the basics of Paint 3D then there is no limit that what can you create using one of the most innovative applications ever developed for Windows. In this tutorial you will leran some of the basics of Paint 3D like Resizing and Rotating the objects etc. You can also learn about Storage and Backup Files Through File History and Storage Sense in Windows 10.

Resizing and Rotating Objects in Paint 3D:

1^st of all you need to open the new document in Paint 3D. For this you need to open the program and click New from the welcome screen.
In the next step you are required to click on the paintbrush icon in the top menu and select 3D shapes. It is the 3D looking box icon in the dropdown.
Now select any of the shapes in the right sidebar and click/drag on the canvas to place it. You can fond the shapes under the 3D objects section but the 3D models are placed the same way.
For rotating the objects you need to grab any of the half or semi circle icons found on the right, top and the bottom sides.
In order to resize you need to drag any of the boxes in the corners. You will see small boxes on the outermost edges if the shapes.

Creating 3D Text in Paint 3D:

In order to create 3D text in Paint 3D you need to follow these simple steps.

1^st of all you need to open Paint 3D and the click on New in order to start a new project.
In the next step you need to select text tool from the menu bar at the top or you can just press “T” on your keyboard.
Now you need to select the three dimensional icon from the sidebar. Now from here you can also select a different font from the menu right below which include size, color, bold, underline and alignment etc.
IN the next step you need to click anywhere on the canvas and then start typing.
Now you are required to click anywhere on the canvas outside of the text box in otder to turn it 3D.
In the next step you need to grab any of the corners of the text box for modifying the size, or one of the four circles to change orientation, depth and angle.

With these simple steps you can easily create the 3D text in Paint 3D.

Storage and Backup of Files Through File History and Storage Sense in Windows 10

File History feature of Windows 10 is one of the easiest to backup your data files and it also allows you to go back in time for retrieving the earleir versions of them. This handy feature thoug available in Windows is turned OFF by default. In order to use the File History you will requrie a second storage device like USB hard drive or SD card to use with the File History. You can use the network location like a shared folder on another PC on your network for the backup location. File History will backup all of your files in your libraries, Desktop, Contacts, Favorites and OneDrive folders. You can also learn about Cortana Tips in Windows 10.

Setting Up the File History:

IN order to set up the File History you need to follow these simple steps.
1^st of all search for the “File History” from the taskbar and then click on “File History settings.”
Now you need to click on “Add a drive” in the Setting app.
Now you need to slect your drive or the network location.
Now scroll down and click on “Show all network locations” to find the shared location.
In the next step you are required to click on “More Options” for customizing the File History.

Restoring a File with File History:

In order to restore a file with File History you need tofollow these simple steps.

1^st of all search for “restore files” from the taskbar and then click on “Restore your files with File History.”
Now you need to navigate to the file or the folder to restore and if you are looking for restoring a previous version of a file use the arrows to see earlier versions of it.
IN the next step you are required to click on Restore button in order to save it in its original location. You can save it on any other location by simply right-clicking on the file and then selecting “Restore to” and selecting a new location.

Freeing Up Disk Space Automatically with Windows 10 Storage Sense:

In order to free up some space with Windows 10 Storage Sense you need to follow these simple steps.

1^st of all you need to right click the Windows icon at the bottom right of the screen and then open the System menu.
In the next step you are required to select Storage from the sidebar at the left.
Now you need to toggle Storage Sense to ON position.
Now if you had like to determine what Storage sense deletes just click on Change how we free up space link below the toggle.
Toggle ON or OFF the desired settings.
With these simple steps you will be able to free up disk space automatically with Windows 10 Storage Sense.

Cortana Tips in Windows 10

Windows 10 has got a built-in digital assistant which will help you to gather important information and manage your schedule. With Cortana you can also send the messages and many more. In this tutorial we will have a look how Cortana will help you in accomplishing various different tasks. You can also learn about Setting a Compatibility Mode for Apps in Windows 10.

Send an Email from Cortana

Sending an Email is sometimes a very laborious activity which needs to open a specific app. For sending the email you start from a draft nd then toggle through a series of fields. Cortana has natural language recognition. Cortana is a feature that has been introduced in Windows 10 which will allow you to send an email easily. In order to send the email with Cortana you need to have an account setup in Windows Mail. For sending an email with Cortana in Windows 10 you need to follow these simple steps.

1^st of all you need to click on “Ask me anything” box and then type or say “I want to send an email to (name of the recipient) followed by the message body.
Now you need to select the contact to whom you need to send the email to. Cortana will prompt you if there are more than one contact which match the name you wrote or spoke.
Once the message is completed you need to click on Send.
With these simple steps you will be able to send your email.

Setting a Reminder with Cortana in Windows 10

In Windows 10 you can tell Cortana to remind you to perform a specific task at a certain time of the day. In order to set a reminder with Cortana you need to follow these simple steps.

1^st of all you need to activate the Cortana or select the “Ask me anything” field.
In the next step you need to write or say “remind me to (activity) in (timeline).
If Cortana did not process your request exactly as you had like then tap on the reminder, day or the time fields and then edit theor contents for making sure the correct reminder is set.
Now if you require the reminder to recur then you need to click on “Only once.”
The reminder can be set in everyday or on specific days of the week.
Now you need to click on Remind once you are satisfied with the terms you have set.

Enabling a Contact Based Reminder:

1^st of all you need to type in the “Ask me anything” prompt that reminds you to tell one of your contacts something.
Now select “Remind” if it is easy to edit the fields if something is incorrect or incomplete. If Cortana dows not recognize the name or you have got more than one contact with the same name then you will be asked to select from a list or browse your contacts. Cortana will conform the reminder.
This reminder will pop-up when you will next communicate with that person.
Now if you need to see all of your reminders you need to click the Lightbulb button in the Cortana menu.

How to Set the Compatibility Mode for Apps in Windows 10

Some of the sofware applications which are developed for the previous versions of Windows can run very well in Windows 10 but you might have some of the older apps which don’t work well and some of them won’t work at all with the new operating system. This issue can be fixed by changing their compatibility mode settings. Windows has got a built-in tool which is known as Program Compatibility Troubleshooter which can fix any compatibility issues automatically. Now if the troubleshooter can not fix the problem you can manually make the application run in the compatibility mode which will run the app using the settings from an earlier version of Windows. You can also learn about Formatting the Tables in MS Excel 2007. Now for using the Windows Program Compatibility Troubleshooter you need to follow these simple steps.

1^st of all in the taskbar search box enter run programs and then click “Run programs made for previous versions of Windows.”
Now in the next step you are required to click Next and the toubleshooter will try to detect the potential issues with your applications.
Now select the app which is having the issues in the next window and then click Next.
Now select a troubleshooting option and use the compatibility setting or select compatibility settings yourself.
If you will select to use the recommended settings, the troubleshooter will test the application by using a previous version of Windows so that you can see if that eliminates the issue.
Now in the next step you are required to click the Test the program button and then after that click on Next.
After this you can either select to save the settings for the app, try different settings or report the problem to Microsoft.

How to Run an App in Compatibility Mode:

As an alternative you can also go to the app’s properties in order to change its compatibility mode settings. With the compatibility mode you can force an app to use the settings from an earlier version of Windows. For running the app in Compatibility mode you need to follow these simple steps.

1^st of all you need to right click on an app and then select Properties. This can be done from the app’s shortcut or by navigating in File Browser to the EXE file.
Now you need to select the Compatibility tab and then click the box next to “Run this program in compatibility mode for:”
In the next step you need to select the version of Windows to use for the settings of your app in the dropdown box.
Now in the next step you are required to hot the Apply button then run your app and see if this is fixed your issues.

With the above mentioned step you will be able to run an application in the compatibility mode in Windows 10.