#ADD BORDER TO TEXT IN EXCEL HOW TO#
How to Add Borders from the Format Cells Dialog BoxĪnother way to add borders to cells or ranges is to use the Format Cells dialog box. If you want more options, though, you can navigate to the Format Cells dialog box. You can also combine 2 to 3 borders or have all 4 borders for each selection.Īdditionally included in this menu are options for various border styles, like thick border, double border, and other common border combinations. You can choose to have individual borders on the top, bottom, left, or right. The Borders button dropdown provides a selection of common border options that you can quickly apply to your selection. The borders provided an instant ‘lift’ to the entire dataset. Here’s how the dataset looks after applying borders: We also added a thick border around the grand total to make it stand out. In our dataset, we applied simple grid-like single borders around each cell.
This will contain quick border options that you can apply to your selected cells. You will find it in the Home tab, under the ‘Font’ group. Click the arrow next to the Borders button.To select a group of cells, drag your mouse over the group of cells you want to select. To select individual cells, press down the control key, and select each cell. Select the cells around which you want to add borders.
We are going to take a look at each of the above ways one by one. By accessing the Format Cell dialog box’s Border tab.By accessing the Border button from the Home tab.There are three ways to add and customize cell borders in Excel: So, it would help if we could make this particular cell more pronounced by adding a thicker border around it. The most important cell in this dataset is the Grand Total.The cells do have gridlines, but they could be more readable if there were borders around every cell containing data.Say we have a dataset as the one given below. The Difference between Borders and Gridlines.
#ADD BORDER TO TEXT IN EXCEL CODE#
You can try following code to fix the height of the row in table: Public Function ConvertRangeToHTMLTable(rInput As Range) As String Select ‘CreateOutlookEmail’ from the list and click on ‘Ok’ button Right click on the shape and select ‘Assign Macro…’Ĩ. Give a name to the shape like ‘Create Email’ħ. Insert a Module (Insert>Module) from menu barĦ. To use this code in your Excel file, follow below steps:ģ. You can read this post to see how to add Outlook Object Library in Excel Reference. It is worth to mention that you must have MS Outlook installed in your system to use this code and you also need to add Outlook reference (Microsoft Outlook XX.X Object Library) in Excel VBA from Menu Bar (Tools>References…). ObjMail.HTMLBody = "This is a test email" & ConvertRangeToHTMLTable(Sheet1.Range("A1:F20")) 'Tip: Here i have converted range A1:F20 of Sheet1 in HTML table, you can modify the same as per your requirement Set objMail = Outlook.CreateItem(olMailItem) StrReturn = strReturn & "" & rCell.Text & ""Įnd Function VBA Code To Copy Excel Range as HTML Table in Outlook Emailīelow Excel Macro creates an email in outlook and call the above function to add Excel Range as HTML Table in Email Body 'This function creates an email in Outlook and call the ConvertRangeToHTMLTable function to add Excel range as HTML table in Email body 'If it is row 1 then it is header row that need to be bold Public Function ConvertRangeToHTMLTable(rInput As Range) As String Below is the code which can make your life easy Excel VBA Code to Convert Excel Range to HTML 'Following function converts Excel range to HTML table To convert Excel range into HTML table, you need to play with HTML tags. It is little difficult in VBA to copy Excel range into email body. Adding an HTML table in email body is very simple task if you do manually, just copy the range in Excel and paste it on email. How to Convert Excel Range into HTML TableĪs a VBA developer you may frequently come cross with a requirement of sending an email through Outlook along with an HTML table inside email body.
0 kommentar(er)
