Hot answers tagged tables
Now there is: Format Text as Table. I've been meaning to create this utility for a while. I was actually inspired by MySQL's command line utility and the lack of tables on SO. So thanks for reminding me to make it. And thanks to @Lipis for the Unicode char idea. Here's an example of the output: +------+--------+--------+ | | ColA | ColB | ...
This Digital Inspiration blog post helped me out. Basically, you can copy content from any web page and paste it into the Gmail rich text editor. The editor will do its best to keep the formatting. In my case, that meant that I had to do the following: Publish the spreadsheet to the web, but just publish the sheet with the data I wanted to copy; Get the ...
I just checked and currently it is not possible to do that, on the table itself. There's however a "hack" option available: add a table in a table, see screenshot: See example doc I've created: table in a table If you set the color of the grid lines to be white, than it will fade away. It will also give you flexibility to position the table off-center. ...
I'm honestly not sure when this was updated, but centering a table directly appears to be possible now. Simply right-click on the table and go to "Table Properties", "Table Alignment", "Center". Click OK.
Create the table in Word then save the document as 'Single File Web Page'; select and copy the table ( Ctrl + C ); paste into your Gmail message ( Ctrl + V ). It brings across the borders, shading, font size, etc. Column width appears to be determined by the number of characters in the column.
I just tried it in Chrome on Windows and it works the following way. Start selecting the table just below the lower-left cell (click where the cursor changes to the one indicating text entry) and drag the selection all the way up to the top-left cell until all of them are filled with a blueish highlight. Then press CTRL + C, switch to Google Spreadsheet and ...
I can confirm that Gmail does allow you to send tables, but provide very limited editing support. What I would do is to copy the whole e-mail into an online HTML editor like TinyMCE and do the editing there. You can also copy it a local tool that supports HTML editing, like Word or Dreamweaver.
You can: Insert a new table row at the new location for the existing row. One cell at a time, cut and paste cell contents from the old row to the new row. Delete the old row. This is obviously not a great solution, but it might be better than recreating the entire table from scratch?
I don't know any but if they are going to use it why not creating something better with ASCII, let's say something like this: ╔══════╤═══════════╤════════╗ ║ ID │ Name │ Age ║ ╠══════╪═══════════╪════════╣ ║ 1 │ John │ 24 ║ ╟──────┼───────────┼────────╢ ║ 2 │ Jeff │ 19 ║ ╟──────┼───────────┼────────╢ ║ 3 │ ...
I've found that Google made this thing called Web Clipboard to handle issues like this. In the Google Drive spreadsheet you're working with, go to Edit → Web Clipboard → Copy Cell Range. Then open a Google Drive document and go to Edit → Web Clipboard and select the cell range you just copied to paste it. Then do a normal copy and paste from this Google ...
I did the following on Windows and it worked. In your google doc, click file and then Download as docx file. Then open it in Word. Select the table in Word and copy it to google spreadsheet. It will keep the format and data. Much better than copy it directly from google doc because it will make all the data go into one column and make it unreadable.
Found this one while looking for simple circuit diagrams , it is the predecessor Ascii Paint You draw and ascii art appears. If you are not good with drawing tables in Word, this might be a bit hard, but it was fun.
Only top voted, non community-wiki answers of a minimum length are eligible