It's a tiny download, at less than KB. This tool provides you with an indepth look at what is eating your CPU cycles, memory and network. Steps : 5 Click Start type resmon in the search box to launch the Resource Monitor. Tip : Take control Tired of the kids installing dubious software or running applications you'd rather they left alone?
AppLocker is a new Windows 7 feature that ensures users can only run the programs you specify. Don't worry, that's easier to set up than it sounds: you can create a rule to allow everything signed by a particular publisher, so choose Microsoft, say, and that one rule will let you run all signed Microsoft applications.
Tip : Calibrate your screen The colours you see on your screen will vary depending on your monitor, graphics cards settings, lighting and more, yet most people use the same default Windows colour profile. And that means a digital photo you think looks perfect might appear very poor to everybody else. Fortunately Windows 7 now provides a Display Colour Calibration Wizard that helps you properly set up your brightness, contrast and colour settings, and a ClearType tuner to ensure text is crisp and sharp.
Windows 10 Troubleshooting By Giga Mirianashvili. Then let go. To make them return, shake the title bar again. You can accomplish the same thing by pressing the Window key-Home key combination -- although doing that is not nearly as much fun. Have a laptop and want to get more battery life out of it?
Windows 7 includes a hidden built-in tool that will examine your laptop's energy use and make recommendations on how to improve it. To use it:. Run a command prompt as an administrator. To do this, type cmd in the search box, and when the cmd icon appears, right-click it and choose "Run as administrator. For about a minute, Windows 7 will examine the behavior of your laptop.
It will then analyze it and create a report in HTML format in the folder you specified. Double-click the file, and you'll get a report -- follow its recommendations for ways to improve power performance. The User Account Control security feature was one of the most reviled additions to Windows Vista, with good reason -- its constant warning messages asking for permission to continue many operations drove users around the bend. UAC has been significantly improved in Windows 7 so that it's not as intrusive as in Vista, but you can still tweak it if you like.
From the screen that appears, use the slider to select the level of protection you want. Here are the four levels and what they mean:. Modifying UAC. Click to view larger image. Always notify me. Think of this as UAC Classic.
It works like Vista's UAC: When you make changes to your system, when software is installed or when a program tries to make a change to your system, an annoying prompt appears. Default -- Notify me only when programs try to make changes to my computer. This is, obviously, the default; make a change yourself and UAC leaves you alone. When a program makes a change, a prompt appears and your desktop goes dark, just like it does in Vista. Otherwise, UAC sits there silently. Notify me only when programs try to make changes to my computer do not dim my desktop.
This setting is identical to the default setting, with one difference: It won't dim your desktop so that you only see the UAC prompt asking you to take action. This presents a slightly elevated security risk over the default setting, because theoretically a program could allow a malicious program to interfere with the UAC prompt.
All you need to do is select the cell where you want to apply the strikethrough and use the below keyboard shortcut. Quick Note: You can use the same shortcut keys if you need to do this for partial text.
It is one of those secret tips which most Excel users are unaware of. Once you install this font, you will have to type the number in a cell for which you want to create a bar-code and then apply the font style. For this, you can apply custom formatting. So, the best way is to highlight them by applying a cell color. In Excel, we can apply custom formatting and in custom formatting, there is an option to use font colors limited but useful.
For example, if you want to use the Green color for positive numbers and the red color for negative numbers then you need to use the custom format. We all have some favorite fonts and colors which we use in Excel.
The point is, you need to do this one by one for each worksheet and that takes time. But if you create a custom theme with your favorite colors and fonts then you can change the style of the worksheet with a single click.
For this, all you have to do is apply your favorite designs to the tables, colors to the shapes and charts, font style and then save it as a custom theme. This is a simple keyboard shortcut that you can use to clear formatting from a cell or range of cells. But there is no option to convert a text into a sentence case. Here is the formula which you can use:. This formula converts the first letter of a sentence into capital and the rest of all in small….
In Excel, there are two specific functions that you can use to generate random numbers. First is RAND which generates random numbers between 0 and 1. ALERT: These both functions are volatile so whenever you re-calculate your worksheet or hit enter, they update their values so make sure to use them with caution. In Excel, there is no specific function to count words. You can count characters with LEN but not words. But, you can use the following formula which can help you to count words from a cell.
This formula counts the number of spaces from a cell and adds 1 to it after that which equals the total number of words in a cell. This mysterious function is specifically made to get the difference between two dates.
I have figured out that there are 4 different ways to calculate the ratio in Excel but using a simple divide method is the easiest one. This formula divides the larger number with the smaller one so that you can take the smaller number as a base 1. To calculate the square root, cube root, or any root of a number the best way is to use the exponent formula. In the exponent formula, you can specify the Nth number for which you want to calculate the root.
To get a total number of days in a month dynamically you can use the following formula:. To simply get the last date of a month you can use the following dynamic formula. If you love to use a line chart, then you are awesome but it would be more awesome if you use a smooth line in the chart. This will give a smart look to your chart. Copy Chart Format in Excel. This charting tip is simple but still quite useful.
But the better way is to hide them instead of deleting them. Here are the steps:. If you are dealing with the large numbers in your chart, you can change the units for axis values. I often use Excel charts with rounded corners and if you like to use round corners too, here are the simple steps. You can use the following options for that empty cell. How to Create a Pictograph in Excel. You can create a chart template to use it anytime in the future and the steps are as follow.
So if your favorite chart is a line chart, then the shortcut is useless for you. Here are the steps to fix this:.
When you hide a cell from the data range of a chart, it will hide that data point from the chart as well. To fix this, just follow these steps.
If you use comments in your reports then you can print them as well. At the end of all printed pages, you can get a list of all the comments. Sometimes we struggle to print entire data on a single page.
Instead of using the page number in the header and footer, you can also use a custom header and footer. Imagine you have fewer data to print on a page. In this case, you can align it at the center of the page while printing. But what if you need to print that range frequently, in that case, you can specify the printing area and print it without selecting it every time. You can replace all the error values while printing with a specific value three other values to use as a replacement.
You can specify that number and the rest of the pages will follow that sequence. Sometimes we need to track some important cells in a workbook and for this, the best way is to use the watch window. In the watch window, you add those important cells and then get some specific information about them in one place without navigating to each cell. Here are the steps to use it:. Flash fill is one of my favorite options to use in Excel.
Let me give you an example. Here are the steps to use it: You have dates in the range A1: A10 and now, you want to get the month from the dates in the B column.
Once you do this it will extract the month from the rest of the dates, just like below. In Excel, using a live image of a table can help you resize it according to space, and to create a live image there are two different ways in which you can use it.
One is camera tools and the second is the paste special option. Here are the steps to use the camera tool and for paste special use the below steps. A few of the Excel users know that there is a default data entry form is there which we can use. And the best part is there is no need to write a single line of code for this. We all have some favorite options or some options which we use frequently.
To access all those options in one place you create a tab and add them to it. Follow these steps:. In simple words, Goal Seek is a problem-solving tool. It helps you find the input value by proving the value you want in the result.
This is an option where you can make Excel speak the text you have entered into a cell or a range of cells. TRIM can help you to remove extra spaces from a text string.
Just refer to the cell from where you want to remove the spaces and it will return the trimmed value in the result. In Excel, to remove these duplicate values is quite simple. Once you click OK, Excel will remove all the rows from the selected data where values are duplicates and show a message with the number of values removed and unique values left.
What is Alt F7? What is Autotext in Word? What is Control a to Z in Computer? What is Ctrl Control? What is Ctrl D in Illustrator? What is Ctrl D? What is Ctrl E in Excel? What is Ctrl F10? What is Ctrl F4? What is Ctrl F? What is Ctrl G? What is Ctrl H? What is Ctrl J in Excel? What is Ctrl M? What is Ctrl N? What is Ctrl Plus Z? What is Ctrl Q? What is Ctrl U for? What is Ctrl V Used for? What is Ctrl W?
What is F12 Key on Hp Laptop? What is F4 in Excel? What is F7 for? What is Fn Key in Hp Laptop? What is Fn Key on Keyboard?
What is Function of F1 to F12 Keys? What is the F4 Key on Hp Laptop? What is the Function of Control a to Z? What is the Function of Ctrl a to Z? What is the Meaning of Ctrl a to Z? What is the Shortcut for Free Transform?
0コメント