The Best Excel Shortcuts You Need to Know

Almost everyone uses Excel in some form or fashion in the modern workforce, but many of us may be wasting a little too much time trying to format those pesky spreadsheets. In order to help you work a little bit faster, or maybe more efficiently. Find below best Excel shortcuts that you need to know!

• F2 : Edit selected cell
• F9 : Calculates all worksheets
• F11 : New chart
• ALT : Access the ribbon for formulas
• ALT + = : Automatically SUM() selected
• ALT + Enter : Start a new line in the same cell
• ALT + o-c-a : Auto size columns
• PG + UP/PG+DOWN : Go to next/previous worksheet
• CTRL + ` : Display Formulas
• CTRL + Backspace : Show active cell
• CTRL + Shift + # : Change Date format with day, month and year.
• CTRL + K : To insert Hyperlink.
• CTRL+ Shift + $ : Applies the currency format to the selected cells.
• CTRL + Shift + & : Applies border to cells
• CTRL + B : Bold
• CTRL + I : Italics
• CTRL + U : Underline
• CTRL + Shift + ~ : General style number
• CTRL + Shift + $ : Currency style number
• CTRL + Shift + % : Percentage style Number
• CTRL + Shift + ^  : Scientific notation style
• CTRL + Shift + # :  Date style
• CTRL + Shift + @ : Time Style
• CTRL + Shift +! : Number Style
• CTRL + F12 : Open
• CTRL + Spacebar : Select the entire column
• CTRL + [ : Select all cells directly referenced by formulas in the selection
• CTRL + A : Select All
• CTRL + Shift + J : List Constants
• CTRL + D : Copy equation down
• CTRL + F : Find
• CTRL + H : Find&Replace
• CTRL + Right arrow : Move right
• CTRL + Left arrow : Move left
• CTRL + Up arrow : Move up
• CTRL + Down arrow : Move down
• CTRL + Enter : Same data in multiple cells
• Shift + Spacebar : Select the entire row
• Shift + F3 : Find Previous

Visual Studio Keyboard Shortcuts

To format document in visual studio
Ctrl + K, D

To comment selected code
Ctrl + K, C

To uncomment selected code
Ctrl + K, U

Show intellisense
Ctrl + Space

Covert selected text to UPPERCASE
Ctrl + Shift + U

Covert selected text to LOWERCASE
Ctrl + U

Toggle Full Screen
Alt + Shift + Enter

Build Project
Shift + F6

Build Solution
Ctrl + Shift + B OR F6

Attach the debugger to a process
Ctrl + Alt + P

Expand or Collapse current element
Ctrl + M, M

Collapse all
Ctrl + M, O

Toggle all Outlining
Ctrl + M, L 

Get FileName list form a Folder in EXCEL

The code below retrieves the file in this directory and creates a list of their names and paths:

Sub GetFileNameList()

Dim objFSO As Object
Dim objFolder As Object
Dim objFile As Object
Dim i As Integer

'Create an instance of the FileSystemObject
Set objFSO = CreateObject("Scripting.FileSystemObject")

'Get the folder object
Set objFolder = objFSO.GetFolder("C:\TMP")

i = 1
'loops through each file in the directory and prints their names and path

For Each objFile In objFolder.Files

    'print file name
    Cells(i + 1, 1) = objFile.Name

    'print file path
    Cells(i + 1, 2) = objFile.path
    i = i + 1

Next objFile

End Sub

Get alternating row colors, using conditional formatting in Excel

I got a questing about how to set alternative color in excel sheet when not using table.

Steps:
1) Select the rows you want alternate color
2) go to Conditional Formatting and create New Rule
3) Select "Use a Formula to determine which cells to format" from rule type
4) Put "=(MOD(ROW(), 2)=0)" without quotes in the formula values
5) Click Format button, and apply format required and that's all..

How to Test a Database Connection String using NotePad

Create and Configure a Universal Data Link (.udl) File with Notepad.

I just came across a way to test a data provider’s connection string (like a SQL Server database) with the help of a plain text file using Notepad.  To investigate and test out if your connection string works, you’re going to want to create a UDL file. 

To do this, follow these steps:

1.Open up Notepad and create an empty text file, then click File -> click Save -> and save it with the File name: TestConnection.udl to your desktop.

2.Go to your desktop and double-click on the TestConnection.udl file you just created and the Data Link Properties box will popup.

3.Select the Provider tab and Find the provider that you want to connect with and click Next >>

4.Now from the Connection tab, select or enter your source/ server name  then enter information to log on to server -> and select the database on the server. 

5.Click Test Connection and click OK to save the file.

Note: If errors occur during testing of your connection string, you will get a popup box with the error message.

Once, you've successfully tested your connection string, now go and compare the details of your TestConnection.udl with your (website) project connection string to see if they are similar.

Reference Site

'Positives in Negatives'

 
A young woman was sitting at her dining table, worried about taxes to be paid, house-work to be done and to top it all, her extended family was coming over for festival lunch the next day. She was not feeling very thankful at that time. 

As she turned her gaze sideways, she noticed her young daughter scribbling furiously into her notebook. 

“My teacher asked us to write a paragraph on “Negative Thanks giving” for homework today.” 
said the daughter.

“She asked us to write down things that we are thankful for, things that make us feel not so good in the beginning, but turn out to be good after all.” 

With curiosity, the mother peeked into the book. This is what her daughter wrote: 

“I’m thankful for Final Exams, because that means school is almost over. 

I’m thankful for bad-tasting medicine, because it helps me feel better. 

I’m thankful for waking up to alarm clocks, because it means I’m still alive.” 

It then dawned on the mother, that she had a lot of things to be thankful for! 

She thought again… 

She had to pay taxes but that meant she was fortunate to be employed. 

She had house-work to do but that meant she had a shelter to live in. 

She had to cook for her many family members for lunch but that meant she had a family with whom she could celebrate. 

Moral:
We generally complain about the negative things in life but we fail to look at the positive side of it. 

What is the positive in your negatives? Look at the better part of life today and make ur everyday a great day. 

Be happy and blessed always.


By :- Anonymous

Count the number of spaces of text string in Excel

Simple to calculate the number of spaces of text string in EXCEL with following formula:

=LEN(A1) - LEN(Substiture(A1," ",""))

Above formula will count all the spaces in the text.


Count the number of leading spaces of text string with formula

=FIND(LEFT(TRIM(A2),1),A2)-1