Tamamlanmış

Google Spreadsheet Expert please help ! (50$)

Google Spreadsheet Expert please help ! (50$)

Hello! Thank you for having interest in this topic.

I am trying to have Google Spreadsheet as my main tool, but still, there are lots of missing points that I am not aware of and not accustomed enough. Maybe not knowing its feature, and now knowing it's shortcut.

So here I have a few questions. About Google spreadsheet usage. Please look into it and see if you can help me out kindly :)

Question 1:

When I write something in google spreadsheet cell, and fill some color inside, and copy this cell,

In my clipboard, it contains not only the texts that written, but also the color's value information of the cell.

So my question is, How would I grab or manipulate those values in clipboard?

Question 2:

related with Question 1, I wonder if I can make some cell directly filling certain color value just having the color code in my clipboard. Not through manual clicking process around tools in Google spreadsheet, I wish I can fell in cell's color just by clipboarded Cell information, which contains the color value (color code)

Do you think it's possible?

For example ) in my clipboard, there could be the cell's already completed information such as "Colorcode = 0x124445 , Rawtext = Work:"

so when I press Ctrl + v, pasting the clipboarded cell information, it automatically even change the color inside of the cell in Google Spreadsheet.

Question 3:

How would I be able to withdraw only plain raw texts from a cell that contains color information inside? so when I paste the clipboarded information, it perfectly fits inside of the cell, whether its color is green or red or black, just fitting in as plain text. not whitening the cell's color.

For example, in Google spreadsheet, we can double-click inside of the cell, then we can grab its plan text. and when pasting it in another cell, we can double click inside of the cell again and paste it, in this case, it perfectly preserve the cell's color even though it's cell copy-paste process. Can we achieve it with simple hotkeys?

Question 4:

When trying to move around the cells inside of google spreadsheet, What I currently do is, (1) Selecting the target cell, (2) Press Ctrl+c (3) Press Esc (to wipe out the original cell info since it's purpose is cell moving) (4) then paste it to target cell position.

but then, for some reason, the format of the moved cell is changed.

for example) When I set the spreadsheet format as text-middle-placed, by pressing Ctrl + a and clicking to text-middle-place, when after moving the cell, the cell's format is changed as text-edgy-placed.

It automatically changes the format when I move around the cells.

Do you have any solution to set default spreadsheet shape? so I don't have to change the cell's format again everytime I move the cells?

Question 5 (Optional): + (10$)

Withdrawing the spreadsheet into my android background.

I want to get the widget of Google Spreadsheet and tried to withdraw my spreadsheet into my Android device background, But everytime I try it fails. And it's only available to withdraw "new-made" spreadsheet.

Will there be any solution for this? when it could be solved, I will reward you further 10$. separately original reward 50$.

Essential Feature note 1:

please be noted that cell-clipboard information manipulation is the main question in this project.

Essential Feature note 2:

If you think you can answer those questions above, please kindly, film/videocapture the process and show me as video tutorial. :)

Thank you for reading! Have a good day and bid me if you think you can build one. Anytime !

And I am willing to respond very quickly to explain more what I exactly need.

also, if you can really make it out well this time in this project, I will promise to carry out further projects with you. Thanks alot.

Beceriler: Veri Girişi, Veri İşleme, Excel, Google Web Yöneticisi Araçları, Web Scraping

Daha fazlasını gör: google earth expert, google news sitemap help, php mysql data google spreadsheet, google sheets advanced tutorial, google sheets help, google sheets advanced tutorial pdf, google sheets, google sheets formulas, google sheets expert, google sheets add ons, google sheets programmer, Spreadsheet expert, expert help word, google maps expert sri lanka, google spreadsheet functions manual, google maps expert webdesign, google spreadsheet data entry, Google API Expert, google finance google spreadsheet, google map expert

İşveren Hakkında:
( 10 değerlendirme ) Incheon, Korea, Republic of

Proje NO: #19224474

Seçilen:

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(1 Yorum)
0.6
romanapanovich

I think I can give You all the answers Let's chat

%selectedBids___i_period_sub_7% gün içinde 60%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(2 Değerlendirme)
3.5

Bu iş için 18 freelancer ortalamada $80 teklif veriyor

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Daha Fazla

$60 USD in 2 gün içinde
(322 Değerlendirme)
7.9
Dhruvika111

Greetings! I have reviewed your job requirement and I am happy to inform that we are a team of well trained dedicated professionals with high proficiency in Excel. Please reply to my bid so that we can discuss more. Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(415 Değerlendirme)
7.9
sonarkaushik

Sir, I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Relevant Skills and Experience Data entry, excel

$50 USD in 3 gün içinde
(109 Değerlendirme)
6.3
Devrits

Hi Hiring manager I have read your all given information in description and i am ready to do various type of work for you and available 24*7*365 for you. 1» I can do Data RESEARCH from any platform for certain subjec Daha Fazla

$50 USD in 0 gün içinde
(45 Değerlendirme)
5.5
MSMralo

Hello ... for answerimg ur first question on how to past only values without the colors or formatted text simply press and hold 3 keys (shift + Ctrl + V) The other questions has some solutions too Relevant Skills Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(44 Değerlendirme)
5.5
Sanjupanchal

Hello there!, I am highly interested in your project I read your project descriptions carefully before bidding. your 100% satisfaction is assured if you allow me to serve. please send me message where we can talk abou Daha Fazla

$50 USD in 3 gün içinde
(40 Değerlendirme)
5.1
Luisedice

Hi! I read all what you need and I'm pretty sure that I can answer all your question, and I can send you a guide, a video, also share information and classes that I've taken for learning.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(4 Değerlendirme)
2.3
ArturQQ

Expert in: ☆ VBA ☆ (Excel, access) ☆ C# ☆ SQL ☆ Google script ☆ Quality and problem oriented solutions guaranteed. Experienced with different kinds of databases and languages. ☆ Professional approach ☆ Attention to de Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
1.4
techlinesols6

"Hi, Hope you are doing well! Thanks for sharing your project requirement with us. It will be our great pleasure to work on your project. I have checked your requirement, yes we can do it, because we already work on si Daha Fazla

$208 USD in 7 gün içinde
(0 Değerlendirme)
0.0
priyankambbs2

I work best i know . Relevant Skills and Experience I am got 87 marks out of 100 in math , I have 1yr experience , I can fill entry . I am best so u hire me , ...

$155 USD in 3 gün içinde
(0 Değerlendirme)
0.0
Gauravsingh2512

I will Complete it in 16 hours if you are interested please reply to my bid and I will also do page layout and formatting to make it attractive Thank you

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
Abhi988

GIVE ME A CHANCE I COMPLETE YOUR WORK EARLY I GOOD IMPRESSION I A BEST IMPRESSION ONE TIME GIVE ME OPPERTUNIEST

$155 USD in 3 gün içinde
(0 Değerlendirme)
0.0
santudalui1994

Dear Sir cordially thanked to you. I would like to do you task wise and precisely. As i have an experience in this field for more than two years.I think i am fit for you job. Daha Fazla

$155 USD in 3 gün içinde
(0 Değerlendirme)
0.0
$155 USD in 3 gün içinde
(0 Değerlendirme)
0.0
Moore2019

Hi, I am comfortable with spreadsheets as I use them daily in my career as an accountant. I would be happy to help you with this, however due to working full time weekends/evenings would be best for me (UK time zone) Daha Fazla

$55 USD in 2 gün içinde
(0 Değerlendirme)
0.0
nivasoftvietnam

ONLY US$3/1HOUR TO HIRE DATA ENTRY/DATA PROCESSING/WEB RESEARCH OPERATOR. I am the leading BPO Company located at Ha Noi, Viet Nam. * I am among TOP 10% of best freelancers. https://www.freelancer.com/u/nivasoftvi Daha Fazla

$50 USD in 3 gün içinde
(0 Değerlendirme)
0.0